[development] ANSI SQL <>

[Gerhard Killesreiter]

-----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-----