Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] MINUS emulation? - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] MINUS emulation?
Date
Msg-id 17758.945659448@sss.pgh.pa.us
Whole thread Raw
In response to MINUS emulation?  (Barry Baldwin <bbaldwin@indyme.com>)
List pgsql-sql
Tree view 
Barry Baldwin <bbaldwin@indyme.com> writes:
> Select field_id, data 
> from table_1
> minus
> Select field_id, data
> from table_2;

The SQL standard spelling for this is "EXCEPT", not "MINUS".
        regards, tom lane

pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] MINUS emulation?
Next
From: "Gerhard Dieringer"
Date:
Subject: Antw: Re: [SQL] group by / having