Damn bug!

From: Date: Thu, 20 Jul 2000 19:13:52 +0000
Subject: Damn bug!
Groups: php.general 
Request: Send a blank email to php-general+get-7466@lists.php.net to get a copy of this message
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

« previous php.general (#7466) next »