[development] ANSI SQL <>

Doug Green douggreen at douggreenconsulting.com
Mon Sep 24 16:04:41 UTC 2007


ANSI 2003 - http://savage.net.au/SQL/sql-2003-2.bnf - search for <not 
equals operator>:

<not equals operator> ::= <less than operator> <greater than operator>

MySQL - http://dev.mysql.com/doc/refman/5.1/en/non-typed-operators.html 
- supports both != and <>
Postgres - http://www.faqs.org/docs/ppbook/c7547.htm - supports both

These aren't the official links (with the exception of MySQL)

Gerhard Killesreiter wrote:
> -----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-----
>
>   


-- 
Doug Green
douggreen at douggreenconsulting.com
904-583-3342

Bringing Ideas to Life with Software Artistry and Invention...



More information about the development mailing list