Re: [SQL] Accessing array datatype

2008-07-28 Thread maria s
don't send private replies, always include the mailing list > address > because someone with more knowledge than me might be able to quickly help > you ;-) > > Best, > Oliveiros > > > - Original Message - > *From:* maria s <[EMAIL PROTECTED]> > *To:* Oliv

Re: [SQL] Accessing array datatype

2008-07-28 Thread Oliveiros Cristina
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

Re: [SQL] Accessing array datatype

2008-07-28 Thread Oliveiros Cristina
Maria, 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