Re: passing user defined data types to stored procedures

On Fri, 14 Nov 2008, Jay Howard wrote:

> Does the driver support passing UDTs as arguments to stored procs?
>

Sort of, but not in the standard fashion. SQLData is not
supported, but it is possible to do it using PGobject (a postgresql
specific extension). If you make your class Foo extend PGobject [1] and
make getType return the type name and getValue return the text
representation that the server expects it will work for sending data to
the server. To get objects of this type back from the server, you must
register them via PGConnection.addDataType [2].

Sample text representation of a complex type:

jurka=# create type mytype as (a int, b text, c date);
CREATE TYPE
jurka=# select '(3,"a,b",2008-11-20)'::mytype;
mytype
----------------------
(3,"a,b",2008-11-20)
(1 row)

Kris Jurka

[1] http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/util/PGobject.html
[2] http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/PGConnection.html#addDataType(java.lang.String,%20java.lang.Class)