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 |
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 |