Forum OpenACS Q&A: Use of != instead of <> in PG queries (for OpenACS 4.x)

Collapse
1: Use of != instead of <> in PG queries (for OpenACS 4.x)
Posted by Roberto Mello on 07/03/01 06:44 PM
I noticed that Oracle queries that use the ^= operator are being to
ported to PG using its non-standard != instead of the standard <>. Is
there a good reason for that?
Collapse
2: Response to Use of != instead of <> in PG queries (for OpenACS 4.x) (response to 1)
Posted by Don Baccus on 07/03/01 07:06 PM
An even better question is why don't the Oracle queries use "<>" in the first place?  Ugh!  I didn't even know Oracle has "^=" as a synonym for "<>"!

We should be changing any such garbage to standard form for both dbs, and this might even make the result standard and thus put into the generic .xql file.  The query extractor can handle this, I can do it in the next few days.

Collapse
3: Response to Use of != instead of <> in PG queries (for OpenACS 4.x) (response to 1)
Posted by Roberto Mello on 07/03/01 07:13 PM
I asked myself the same question... Using Oracle-specific features where applicable because a standard is not available may be acceptable. But using them when a standard is available and supported is plainly dumb.