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
begin:vcard
n:Huang;Bernie
tel;fax:(604)664-9195
tel;work:(604)664-9172
x-mozilla-html:TRUE
org:Environment Canada;Standards and Technology Services
adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada
version:2.1
email;internet:[EMAIL PROTECTED]
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard
