Postgres Pro
Downloads
Home   >   mailing lists

traversing an array column - Mailing list pgsql-jdbc

From agnes
Subject traversing an array column
Date
Msg-id 004601c2ff00$55628cc0$0bac22cb@a7g6n8
Whole thread Raw
List pgsql-jdbc
Tree view
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


pgsql-jdbc by date:

Previous
From: "Chris White"
Date:
Subject: Re: [ADMIN] Problems with Large Objects using Postgres 7.2.1
Next
From: "Dirk Bromberg"
Date:
Subject: Re: Problems retrieving data from bytea field