Re: [Pharo-users] Prepared statements with PostgresV2

On 28/10/2013 1:59 PM, Esteban A. Maringolo wrote:

I'm using PGConnection from the PostgresV2 package.

conn execute: 'SELECT * FROM MYTABLE WHERE COLUMN = ?' withAll: (Array with: columnValue)

How can I do this?

You cannot do it with the V2 protocol. I just looked over the postgres docs at: http://www.postgresql.org/docs/7.4/static/protocol.html http://www.postgresql.org/docs/7.3/static/protocol.html The feature you want is called "Extended Query" in the postgres docs, and is appears in PostgreSQL 7.4, but not in PostgreSQL 7.3. Note also that the V2 Frontend/Backend Protocol is used for PostgreSQL 7.3., whereas the V3 Protocol is used for PostgreSQL 7.4.