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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general