# Poco::Data::PostgreSQL

# class Binder

Library: Data/PostgreSQL
Package: PostgreSQL
Header: Poco/Data/PostgreSQL/Binder.h

## Description

Binds INPUT (only) placeholders in the sql query to the provided values. Allows data type mapping at statement execution time.

## Inheritance

Direct Base Classes: Poco::Data::AbstractBinder

All Base Classes: Poco::Data::AbstractBinder

## Member Summary

Member Functions: bind, bindVector, size, updateBindVectorToCurrentValues

Inherited Functions: bind, isInBound, isOutBound, reset, reverseTranscode, toString, transcode, transcodeRequired

## Types Aliases

### Ptr

using Ptr = SharedPtr < Binder >;

## Constructors

### Binder

Binder();

Creates the Binder.

## Destructor

### ~Binder

virtual ~Binder() override;

Destroys the Binder.

## Member Functions

### bind

virtual void bind(
std::size_t pos,
const Poco::Int8 & val,
Direction dir = PD_IN
) override;

Binds an Int8.

See also: Poco::Data::AbstractBinder::bind()

### bind

virtual void bind(
std::size_t pos,
const Poco::UInt8 & val,
Direction dir = PD_IN
) override;

Binds an UInt8.

See also: Poco::Data::AbstractBinder::bind()

### bind

virtual void bind(
std::size_t pos,
const Poco::Int16 & val,
Direction dir = PD_IN
) override;

Binds an Int16.

See also: Poco::Data::AbstractBinder::bind()

### bind

virtual void bind(
std::size_t pos,
const Poco::UInt16 & val,
Direction dir = PD_IN
) override;

Binds an UInt16.

See also: Poco::Data::AbstractBinder::bind()

### bind

virtual void bind(
std::size_t pos,
const Poco::Int32 & val,
Direction dir = PD_IN
) override;

Binds an Int32.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Poco::UInt32 & val,
Direction dir = PD_IN
) override;

Binds an UInt32.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Poco::Int64 & val,
Direction dir = PD_IN
) override;

Binds an Int64.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Poco::UInt64 & val,
Direction dir = PD_IN
) override;

Binds an UInt64.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const bool & val,
Direction dir = PD_IN
) override;

Binds a boolean.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const float & val,
Direction dir = PD_IN
) override;

Binds a float.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const double & val,
Direction dir = PD_IN
) override;

Binds a double.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const char & val,
Direction dir = PD_IN
) override;

Binds a single character.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::string & val,
Direction dir = PD_IN
) override;

Binds a string.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Poco::Data::BLOB & val,
Direction dir = PD_IN
) override;

Binds a BLOB.

### bind

void bind(
std::size_t pos,
const Poco::Data::CLOB & val,
Direction dir = PD_IN
) override;

Binds a CLOB.

### bind

void bind(
std::size_t pos,
const DateTime & val,
Direction dir = PD_IN
) override;

Binds a DateTime.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Date & val,
Direction dir = PD_IN
) override;

Binds a Date.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const Time & val,
Direction dir = PD_IN
) override;

Binds a Time.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const UUID & val,
Direction dir = PD_IN
) override;

Binds a UUID.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const NullData & val,
Direction dir = PD_IN
) override;

Binds a null.

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::Int8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::Int8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::Int8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::UInt8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::UInt8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::UInt8 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::Int16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::Int16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::Int16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::UInt16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::UInt16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::UInt16 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::Int32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::Int32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::Int32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::UInt32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::UInt32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::UInt32 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::Int64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::Int64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::Int64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Poco::UInt64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Poco::UInt64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Poco::UInt64 > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < bool > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < bool > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < bool > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < float > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < float > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < float > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < double > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < double > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < double > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < char > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < char > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < char > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < BLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < BLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < BLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < CLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < CLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < CLOB > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < DateTime > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < DateTime > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < DateTime > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Date > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Date > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Date > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < Time > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < Time > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < Time > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < NullData > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < NullData > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < NullData > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::vector < std::string > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::deque < std::string > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bind

void bind(
std::size_t pos,
const std::list < std::string > & val,
Direction dir = PD_IN
) override;

See also: Poco::Data::AbstractBinder::bind()

### bindVector

InputParameterVector bindVector() const;

Return the vector of bound parameters.

### size

std::size_t size() const;

Return count of bound parameters

### updateBindVectorToCurrentValues

void updateBindVectorToCurrentValues();

obtain the current version of the bound data and update the internal representation