Re: Except does not work as in the documentation

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Except does not work as in the documentation
Дата
Msg-id CAKAnmmJO=OZhb0Winr5XYary71tFQe1i_jzb6bMqH2C2P9AsPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Except does not work as in the documentation  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
Дерево обсуждения
Your BETWEEN statement has X AND Y inside of parenthesis. No parenthesis are needed, the format is:

BETWEEN X AND Y

not 

BETWEEN (X AND Y)

See:


Postgres is complaining about the EXCEPT because it is waiting for the next item in the BETWEEN clause. It just happened to be in the line of fire - any other word would have triggered an error as well.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

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