Re: SQL Question - Mailing list pgsql-general

From John R Pierce
Subject Re: SQL Question
Date
Msg-id 533B27F7.4040608@hogranch.com
Whole thread Raw
In response to Re: SQL Question  (Robert DiFalco <robert.difalco@gmail.com>)
List pgsql-general
On 4/1/2014 1:27 PM, Robert DiFalco wrote:
> Heh, scratch that, the EXISTS query DOES work. Is this the most
> efficient way to perform this kind of query? Thanks!

I would try and express that as a left outer join, and use (c2.owner_id
IS NOT NULL)  as your boolean field (or something like that)





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: simple update query stuck
Next
From: David Johnston
Date:
Subject: Re: simple update query stuck