that
>> array_upper( your_array, 1 ) returns the upper bound of the array...
>>
>> Can this be what you need...?
>>
>>
>> Best,
>> Oliveiros
>>
>> - Original Message -----
>> *From:* maria s <[EMAIL PROTECTED]>
>> *To:* Osvaldo R
To: Oliveiros Cristina
Sent: Monday, July 28, 2008 6:03 PM
Subject: Re: [SQL] Accessing array datatype
Hi Oliveiros,
Thank you so much for your reply.
I would like to get the elements of an array as columns instead of getting
them as {a,b,..}
May be if I know the array boundary, then
what you need...?
Best,
Oliveiros
- Original Message -
From: maria s
To: Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan
Sergio Borgonovo
Sent: Monday, July 28, 2008 5:09 PM
Subject: [SQL] Accessing array datatype
Hi All,
I have an array
Hi All,
I have an array column in a table.
How can I fetch the elements separately( ie, select arr[1],arr[2]...arr[n])
as a column,
when I don't know how many elements are there in the array?
Thanks for your help.
Maria