Re: Left Join Complex Query

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Left Join Complex Query
Date: 2001-02-02 17:26:54
Message-ID: 006301c08d3d$5fd96ca0$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Far simpler way to do this, without outer join:
>
> select bc.b,bc.c, (select count(*) from abc where bc.....)::boolean

You're absolutely right... I hate it when I make it too hard on myself!
Thanks for the replies!

Greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-02-02 17:37:08 Re: plpgsql always returning null..
Previous Message Lamar Owen 2001-02-02 17:23:37 Re: Perl Interface Documentation