Re: Select Rows With Only One of Two Values [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Select Rows With Only One of Two Values [RESOLVED]
Date: 2012-07-20 16:21:04
Message-ID: alpine.LNX.2.00.1207200918470.21688@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-07-20 16:25:28 Re: Select Rows With Only One of Two Values [RESOLVED]
Previous Message Chris Angelico 2012-07-20 16:15:45 Re: Select Rows With Only One of Two Values