| From: | <terry(at)ashtonwoodshomes(dot)com> |
|---|---|
| To: | "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, "'Greg Donald'" <greg(dot)donald(at)nukote(dot)com>, "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: <> syntax legal? |
| Date: | 2004-09-01 15:58:15 |
| Message-ID: | 00c501c4903c$7e5d55a0$2766f30a@development.greatgulfhomes.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)greatgulfhomes(dot)com
Fax: (416) 441-9085
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-09-01 16:18:59 | PostgreSQL 8.0.0 Beta 2 Uploaded |
| Previous Message | Peter Eisentraut | 2004-09-01 15:51:26 | Re: stand-alone psql |