| From: | "agnes" <poohie(at)connexus(dot)net(dot)au> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | traversing an array column |
| Date: | 2003-04-10 01:27:20 |
| Message-ID: | 004601c2ff00$55628cc0$0bac22cb@a7g6n8 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi,
I'm using the pg_constraint system catalog and want to extract the column conkey, which is stored as an int2[], using JDBC. I'm using getArray to extract the array and getResultSet to then extract the actual values in the array, and thats working however I was wondering whether anyone knows of any other way to do it? Is there a simpler method?
Is there any way to traverse an int2 array (not int4 - since there is the *= method for int4 ONLY) using sql?
Thanks for your time
Agnes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Bromberg | 2003-04-10 05:41:58 | Re: Problems retrieving data from bytea field |
| Previous Message | Chris White | 2003-04-09 22:56:19 | Re: [JDBC] Problems with Large Objects using Postgres 7.2.1 |