-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Doug Green schrieb:
Yesterday I noticed that we use the SQL != syntax instead of the ANSI standard <> syntax. This seems like a cross-database compatability problem to me, and I've written a coder rule in the SQL review to check for it. It found about 20 uses of this in core. But I haven't committed it yet. I'd like to get feedback if others think that this is a problem.
Can you give us links to: 1) the ANSI specs, 2) the MySQL and postgres specs which mention thie operator? If it indeed is ANSI and both MySQL and Postgres are fine with it I propose to change the coding standard to demand <> being used. Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG98mMfg6TFvELooQRAlo7AJ42nP40k/vf2B9YKxU8s4oeZo3FSwCfXGt1 3mCxTat3TCt9hyZaLi0vrIs= =tnkf -----END PGP SIGNATURE-----