update custom types via resultset

From: Robert Wimmer <seppwimmer(at)hotmail(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: update custom types via resultset
Date: 2007-10-23 14:53:32
Message-ID: BAY139-W134257831F2A5744C665CAD09B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-jdbc by date

  From Date Subject
Next Message LiuYan 刘研 2007-10-23 15:16:38 Chinese database name in URL, can I ?
Previous Message Kris Jurka 2007-10-20 17:48:34 Re: Unable to prepare a statement when the object names contain more than one $ symbol