Thread: <> syntax legal?

Is it legal syntax to use <> instead of != in a Postgres query?

I didn't see it listed on:

http://www.postgresql.org/docs/7.4/static/sql-syntax.html

but wanted to ask to make sure.



--
Greg Donald

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/

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
>