Fetch an element in an array

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Fetch an element in an array
Date: 2000-06-08 00:21:52
Message-ID: 393EE720.65EDA03F@ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
bernie.huang.vcf text/x-vcard 315 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Hiroshi Inoue 2000-06-08 00:24:50 RE: Problem with subquery in CHECK constraint.
Previous Message Bruce Momjian 2000-06-08 00:15:58 Re: counting distinct values