Damn bug!
| From: | Bernie Huang | 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