Re: != should give error?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: != should give error?
Дата
Msg-id 20171221154233.6ofcaah3sk5uctck@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: != should give error?  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
Список pgsql-hackers
Dagfinn Ilmari Mannsåker wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Дата:
Сообщение: Re: != should give error?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: force parallel mode vs CTAS