Markus,
>Maybe your postgresql driver only uses text transfer up to now.
>asBinary() returns a byte array, so this should be transferred more
>efficiently.
I'm using the JDBC3 build 310 drivers (latest from jdbc.postgresql.org).
>Can you try the following query:
>
>select 5::float8,asBinary('POINT(0 0)')::bytea
>
asBinary() already returns a bytea:
#\df asbinary
List of functions
Schema | Name | Result data type | Argument data types
--------+----------+------------------+---------------------
public | asbinary | bytea | geometry
public | asbinary | bytea | geometry, text
(2 rows)
But, I tried your query and it, also, sends 84 bytes.
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/