Fetch an element in an array
| From: | Bernie Huang | Date: | Wed, 07 Jun 2000 23:28:06 +0000 |
| Subject: | Fetch an element in an array | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-255@lists.php.net to get a copy of this message | ||
Hi,
I remember I've seen this in php-list, but I didn't keep the message.
Question is 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