Fetch an element in an array - Mailing list pgsql-sql

From Bernie Huang
Subject Fetch an element in an array
Date
Msg-id 393EE720.65EDA03F@ec.gc.ca
Whole thread Raw
List pgsql-sql
Hi,

This is more of a PHP problem, but I wish if someone knows this can help
me.  How do I fetch an element in a Postgres array?

I have a table like

employee
--------
col1 int4
col2 text[]

now I used the php api

$row = pg_fetch_array($exec, 0);

which gives me the following:

echo $row['col2'];
(prints out ===>  {"123-4567", "Bernie", "123-5670"} )

(echo $row['col2[2]'];  <=== didn't work)

What can I do to extract only the "Bernie" element?

Thanks.


- Bernie
Attachment

pgsql-sql by date:

Previous
From: "Vincenzo Passoli"
Date:
Subject: RE: Re: how to know when a table is altered
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Problem with subquery in CHECK constraint.