It's not just legal, <> is the official SQL compliant non-equality operator.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com
Fax: (416) 441-9085
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Peter
> Eisentraut
> Sent: Wednesday, September 01, 2004 11:49 AM
> To: Greg Donald; pgsql-general
> Subject: Re: [GENERAL] <> syntax legal?
>
>
> Greg Donald wrote:
> > Is it legal syntax to use <> instead of != in a Postgres query?
>
> peter=# SELECT (1 <> 2) != (3 <> 4);
> ?column?
> ----------
> f
> (1 Zeile)
>
> All signs point to "yes".
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>