Re: SQL Question

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL Question
Date: 2014-04-01 20:56:23
Message-ID: 533B27F7.4040608@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2014-04-01 21:24:38 Re: simple update query stuck
Previous Message Andrew Sullivan 2014-04-01 20:51:20 Re: simple update query stuck