<> 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
Show quoted text
-----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