Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Kelly Burkhart
On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer AFAIK, the `timestamp' type moved from a floating-point to an integer representation internally, which would've affected the binary protocol representation. That was even a

Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Merlin Moncure
On Tue, Mar 1, 2011 at 8:19 AM, Kelly Burkhart kelly.burkh...@gmail.com wrote: On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer AFAIK, the `timestamp' type moved from a floating-point to an integer representation

Re: [GENERAL] Binary params in libpq

2011-03-01 Thread Tom Lane
Kelly Burkhart kelly.burkh...@gmail.com writes: On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure mmonc...@gmail.com wrote: Actually, this has always been a compile time option on the server as far as i remember and there is protocol support for it -- libpq tells you how it has been set...you've

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Merlin Moncure
On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer cr...@postnewspapers.com.au wrote: On 28/02/2011 7:48 AM, Merlin Moncure wrote: How stable is the binary representation for the PostgreSQL types? We may just pass bytea data in binary format and pass everything else as text parameters, or pass

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Daniele Varrazzo
On Mon, Feb 28, 2011 at 2:42 PM, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Feb 27, 2011 at 7:39 PM, Craig Ringer AFAIK, the `timestamp' type moved from a floating-point to an integer representation internally, which would've affected the binary protocol representation. That was even a

Re: [GENERAL] Binary params in libpq

2011-02-28 Thread Craig Ringer
On 28/02/2011 10:42 PM, Merlin Moncure wrote: Actually, this has always been a compile time option on the server as far as i remember and there is protocol support for it -- libpq tells you how it has been set...you've always had to deal with this (libpqtypes, which I've mentioned several times

[GENERAL] Binary params in libpq

2011-02-27 Thread Daniele Varrazzo
Hello, I'm thinking about adding support for PQexecParams and PQprepare in Psycopg. I've posted more details yesterday on the Psycopg mailing list http://archives.postgresql.org/psycopg/2011-02/msg00076.php. I have a few preliminary questions: How stable is the binary representation for the

Re: [GENERAL] Binary params in libpq

2011-02-27 Thread Merlin Moncure
On Sun, Feb 27, 2011 at 1:13 PM, Daniele Varrazzo daniele.varra...@gmail.com wrote: Hello, I'm thinking about adding support for PQexecParams and PQprepare in Psycopg. I've posted more details yesterday on the Psycopg mailing list http://archives.postgresql.org/psycopg/2011-02/msg00076.php. I

Re: [GENERAL] Binary params in libpq

2011-02-27 Thread Craig Ringer
On 28/02/2011 7:48 AM, Merlin Moncure wrote: How stable is the binary representation for the PostgreSQL types? We may just pass bytea data in binary format and pass everything else as text parameters, or pass different types too as binary, if performace would benefit. Did binary format ever