Request a Demo
Home   >   mailing lists

Accessing array datatype - Mailing list pgsql-sql

From maria s
Subject Accessing array datatype
Date
Msg-id d9d42a0f0807280909o50b46828yc68e0b05f27de175@mail.gmail.com
Whole thread Raw
List pgsql-sql
Tree view
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: "Chris Preston"
Date:
Subject: Encrytion in postgres field in table
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Accessing array datatype