note 62000 deleted from function.pg-query by nlopess
| From: | nlopess@php.net | Date: | Fri, 17 Feb 2006 11:13:55 +0000 |
| Subject: | note 62000 deleted from function.pg-query by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-103899@lists.php.net to get a copy of this message | ||
Note Submitter: acloutier at algebrik dot com
----
For MySQL user, you can have a problems with a logical operators :
with MySQL you can use "&&" for "AND" operator or "||" for
"OR" operator.
With PgSQL you must use "AND", "OR" operator. The SQL standards are very
important for PostgreSQL use.
Examples :
With MySQL : select * from mydatabase where field1=condition1 && field2=condition2;
With PgSQL : select * from mydatabase where field1=condition1 AND field2=condition2;
Alain Cloutier
http://www.virtual-world.org
http://www.algebrik.com