You mean your array has a variable size, which you need to know in order to properly construct a query?
Dunno much about arrays, but here http://www.postgresql.org/docs/8.3/static/arrays.html is said that array_upper( your_array, 1 ) returns the upper bound of the array...
Can this be what you need...?
----- Original Message -----
From: maria s
To: Osvaldo Rosario Kussama ; pgsql-sql(at)postgresql(dot)org ; Pavel Stehule ; Ivan Sergio Borgonovo
Sent: Monday, July 28, 2008 5:09 PM
Subject: [SQL] Accessing array datatype
I have an array column in a table.
How can I fetch the elements separately( ie, select arr,arr...arr[n]) as a column,
when I don't know how many elements are there in the array?
Thanks for your help.
In response to
pgsql-sql by date
|Next:||From: Oliveiros Cristina||Date: 2008-07-28 17:21:14|
|Subject: Re: Accessing array datatype|
|Previous:||From: maria s||Date: 2008-07-28 16:09:31|
|Subject: Accessing array datatype|