Re: DB_NestedSet db incompatibilities?
| From: | Alexey Borzov | Date: | Thu, 06 Nov 2003 10:40:06 +0000 |
| Subject: | Re: DB_NestedSet db incompatibilities? | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-23279@lists.php.net to get a copy of this message | ||
Hi!
Daniel Khan wrote:
I am trying to catch up as didn't read much mail while beeing at the phpcon. Unfortunately I can't find the first post by Alexey anywhere so a link to it would be helpful.It was sent to Andy only, but he fully quoted it in the list. The relevant part is: I tried running it with Postgres not long ago and found two incompatibilities: 1) Usage of "INSERT INTO tablename SET field1=value1" syntax. I believe this to be quite non-standard. 2) Usage of IF(..., ..., ...) within queries. I think CASE is a standard construct and it is supported by Postgres.
As I don't have access to all available RDBM's I would be happy if other people would also test and report problems.Though I am not going to use this myself, I can help with testing on Postgres.