update custom types via resultset - Mailing list pgsql-jdbc

From Robert Wimmer
Subject update custom types via resultset
Date
Msg-id BAY139-W134257831F2A5744C665CAD09B0@phx.gbl
Whole thread Raw
List pgsql-jdbc
My question is - is there a possibility to update or insert user defined types in a table via a resultset.

for example :

CREATE TYPE t0type AS (a INT PRIMARY KEY, b INT );
CREATE TABLE t1 (id INT, t0 t0type);


id like to avoid java commands like

query = "UPDATE t1 (t0).a = 12, (t0).b WHERE id = 23";

i would prefer to use the resultset syntax like

rs.update??("t0",??)

or is there any workaround

thanks Sepp
_________________________________________________________________
Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden!
http://www.livemessenger-emoticons.com/de-at/

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Unable to prepare a statement when the object names contain more than one $ symbol
Next
From: LiuYan 刘研
Date:
Subject: Chinese database name in URL, can I ?