Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group