Postgres Pro
Downloads
Home   >   mailing lists

Re: Except does not work as in the documentation - Mailing list pgsql-docs

From Greg Sabino Mullane
Subject Re: Except does not work as in the documentation
Date
Msg-id CAKAnmmJO=OZhb0Winr5XYary71tFQe1i_jzb6bMqH2C2P9AsPQ@mail.gmail.com
Whole thread Raw
In response to Except does not work as in the documentation  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
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 by date:

Previous
From: PG Doc comments form
Date:
Subject: Except does not work as in the documentation
Next
From: "Euler Taveira"
Date:
Subject: Re: correction