[development] ANSI SQL <>
gerhard at killesreiter.de
Mon Sep 24 14:28:28 UTC 2007
-----BEGIN PGP SIGNED MESSAGE-----
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
-----END PGP SIGNATURE-----
More information about the development