| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | makams(at)labcorp(dot)com |
| Subject: | Except does not work as in the documentation |
| Date: | 2025-02-25 17:37:43 |
| Message-ID: | 174050506399.1964953.12433408927009759611@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/queries-union.html
Description:
The current documentation does not give the right syntax for using the
EXCEPT in a query.
This is the error when I ran the below:
select appt_id from wayfinder.patient_details where create_timestamp between
('2025-02-24 00:00:00' and '2025-02-25 00:00:00')
EXCEPT
select appt_id from wayfinder.appointment_details where create_timestamp
between ('2025-02-24 00:00:00' and '2025-02-25 00:00:00')
ERROR: syntax error at or near "EXCEPT"
LINE 2: EXCEPT
^
SQL state: 42601
Character: 128
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2025-02-25 21:22:34 | Re: Except does not work as in the documentation |
| Previous Message | Amit Kapila | 2025-02-25 05:31:56 | Re: pg_copy_logical_replication_slot doesn't copy the failover property |