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: (view raw, whole thread or download thread mbox)
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.



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-2017 The PostgreSQL Global Development Group