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