Re: HELP WITH A QUERY

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: HELP WITH A QUERY
Date: 2010-11-25 01:36:20
Message-ID: 4CEDBD94.401@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 11/24/2010 06:16 PM, JORGE MALDONADO wrote:
> I guess that a query with a subselect and the EXCEPT keyword would
> work but I would like to know if there is a simpler alternative?

How about "NOT EXISTS"?

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2010-11-25 01:40:10 Re: Multi-row insert using a Function
Previous Message Jasen Betts 2010-11-25 01:35:21 Re: HELP WITH A QUERY