Accessing array datatype

From: "maria s" <psmg01(at)gmail(dot)com>
To: "Osvaldo Rosario Kussama" <osvaldo(dot)kussama(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Subject: Accessing array datatype
Date: 2008-07-28 16:09:31
Message-ID: d9d42a0f0807280909o50b46828yc68e0b05f27de175@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros Cristina 2008-07-28 16:56:11 Re: Accessing array datatype
Previous Message Chris Preston 2008-07-28 13:25:38 Encrytion in postgres field in table