replace EXCEPT by JOIN - Mailing list pgsql-sql

From T E Schmitz
Subject replace EXCEPT by JOIN
Date
Msg-id 461E7B2A.6040507@numerixtechnology.de
Whole thread Raw
List pgsql-sql
The following construct does what I need but is there a better way of 
expressing this?



select * from
(

SELECT DISTINCT section.section_pk
FROM ITEM LEFT JOIN product product ON Item.product_fk = product.product_pk LEFT JOIN section section ON
product.section_fk= section.section_pk
 
WHERE item.export = 'f'

EXCEPT

SELECT DISTINCT section.section_pk
FROM ITEM LEFT JOIN product product ON Item.product_fk = product.product_pk LEFT JOIN section section ON
product.section_fk= section.section_pk
 
WHERE item.export = 't'

) as X


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: ERROR: column "crc" does not exist
Next
From: PostgreSQL Admin
Date:
Subject: Re: Replace string