Skip site navigation (1) Skip section navigation (2)

updating Arrays

From: Guido Fiala <guido(dot)fiala(at)dka-gmbh(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: updating Arrays
Date: 2004-08-12 06:49:21
Message-ID: 200408120849.21875.guido.fiala@dka-gmbh.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hallo,

while using the datatype array with getObject() one can easily work with
getArray() and has the data available.

But i have some problems to understand how the opposite way works,
the method updateObject() does take an array too or using updateArray()
in the following cases:

-getArray() returns null, but the user wants to inserts some values
-getArray() returns an array with say, 4 elements, the user wants to insert 
one with more or less than 4 dimensions
-getArray() returns an array and the user just wants to changes some values in

How can i achieve this? (for various datatypes)
Do i really need an prepared Statement? (so far i don't need that in my app)

Thanks for any help,
Guido


pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-08-12 22:38:47
Subject: Bump JDBC build number for upcoming 7.4.4 release?
Previous:From: Oliver JowettDate: 2004-08-12 05:41:18
Subject: Re: [GENERAL] Resultset problem or BUG !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group