Re: [SQL] Fetch an element in an array

2000-06-08 Thread omid omoomi
$row = pg_fetch_array($exec, 1); echo $row['col2']; Regards Omid Omoomi >From: Bernie Huang <[EMAIL PROTECTED]> >To: PGSQL-SQL <[EMAIL PROTECTED]> >Subject: [SQL] Fetch an element in an array >Date: Wed, 07 Jun 2000 17:21:52 -0700 > >Hi, > >This i

[SQL] Fetch an element in an array

2000-06-07 Thread Bernie Huang
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'