note 92469 deleted from function.pg-convert by danbrown
| From: | danbrown@php.net | Date: | Sun, 26 Jul 2009 15:52:14 +0000 |
| Subject: | note 92469 deleted from function.pg-convert by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-158744@lists.php.net to get a copy of this message | ||
Note Submitter: jasperhorn at gmail dot com
----
Andrew, you claim that the postgreSQL states you can do it that way. That claim is false.
It says the string 'true' can be used - which is not the string 'TRUE' - and
that the keyword TRUE (no quotes) can be used - which is not the string 'TRUE' either.
To illustrate the difference between the keyword and the string:
SET field = 'TRUE' // string, thus invalid
SET field = TRUE // keyword, thus valid
It is to be noted that this function does not support the keyword and as such, you will have to use
a string representation, which the capital version is not.