Postgres Pro
Downloads
Home   >   mailing lists

Re: Accessing array datatype - Mailing list pgsql-sql

From Oliveiros Cristina
Subject Re: Accessing array datatype
Date
Msg-id 020001c8f0d2$d6e88460$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to Accessing array datatype  ("maria s" <psmg01@gmail.com>)
List pgsql-sql
Tree view
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 s
Sent: Monday, July 28, 2008 5:09 PM
Subject: [SQL] Accessing array datatype

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

pgsql-sql by date:

Previous
From: "maria s"
Date:
Subject: Accessing array datatype
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Accessing array datatype