Hi,

Sorry for the subject, but it is driving me crazy that I spend my entire
morning searching for this little bug.  =(

Well, I found it.

I have a field using array (eg; col1 text[]) in Postgres, and it's a
list of attributes.  (eg; {"hi","hello","whatever","Empty",...})

When I tried to update elements in the array via PHP script,

$query = "update table
          set col1[1]='$var1',
              col1[2]='$var2',
              ...
              col1[4]='$var4'";

it worked alright; however, when it came to the word 'Empty', it just
wouldn't update. So, after a lot of struggle... )xp ... I finally
replaced the word 'Empty' with 'None' or something alike, and it worked!

Although this is a rare case, I thought I would just share this with you
so you won't get tripped over it.  Don't know if it's a PHP bug or a
Postgres bug!


- 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

Reply via email to