Re: Accessing array datatype
| От | Oliveiros Cristina |
|---|---|
| Тема | Re: Accessing array datatype |
| Дата | |
| Msg-id | 020001c8f0d2$d6e88460$ec5a3d0a@marktestcr.marktest.pt обсуждение |
| Ответ на | Accessing array datatype ("maria s" <psmg01@gmail.com>) |
| Список | pgsql-sql |
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 what you need...?
Best,
Oliveiros
----- Original Message -----From: maria sSent: Monday, July 28, 2008 5:09 PMSubject: [SQL] Accessing array datatypeHi 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
В списке pgsql-sql по дате отправления: