| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org> |
| Cc: | Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: !<space>= should give error? |
| Date: | 2017-12-21 15:42:33 |
| Message-ID: | 20171221154233.6ofcaah3sk5uctck@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dagfinn Ilmari Mannsåker wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > Yes, <> is the operator mandated by the SQL standard. I don't think !=
> > appears anywhere -- it's our extension only and thus if you use it you
> > should not expect your applications to work on other DBMSs.
> So while it might not be standard SQL, it's definitely not "our
> extension only".
Well, that means everybody else also extends, but since it's not
standard, the operator could mean something different and if your app
breaks because of that, you get to keep the pieces.
As in some other thread, "we're in {good company, bad society}" in this
regard.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-12-21 15:44:24 | Re: force parallel mode vs CTAS |
| Previous Message | Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= | 2017-12-21 15:35:14 | Re: !<space>= should give error? |