On Sat, 21 Jul 2012, Chris Angelico wrote:

Try this:

SELECT DISTINCT param FROM table WHERE indicator=0
EXCEPT
SELECT DISTINCT param FROM table WHERE indicator=1

Chris,

  Thank you. I knew it was simple, and I've not before used the EXCEPT
condition.

Very much appreciate,

Rich


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to