Re: Select Rows With Only One of Two Values [RESOLVED] - Mailing list pgsql-general

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