Re: Except does not work as in the documentation

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: makams(at)labcorp(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Except does not work as in the documentation
Date: 2025-02-25 21:22:34
Message-ID: CAKAnmmJO=OZhb0Winr5XYary71tFQe1i_jzb6bMqH2C2P9AsPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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:

https://www.postgresql.org/docs/current/functions-comparison.html

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

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Euler Taveira 2025-02-27 22:57:37 Re: correction
Previous Message PG Doc comments form 2025-02-25 17:37:43 Except does not work as in the documentation