Home > mailing lists

Re: Left Join Complex Query - Mailing list pgsql-general

From	Gregory Wood
Subject	Re: Left Join Complex Query
Date	February 2, 2001 15:25:21
Msg-id	006301c08d3d$5fd96ca0$7889ffcc@comstock.com Whole thread Raw
In response to	Re: Left Join Complex Query (Alex Pilosov <alex@pilosoft.com>)
List	pgsql-general

Tree view

> 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

pgsql-general by date:

From: Lamar Owen
Date: 02 February 2001, 15:24:07
Subject: Re: Perl Interface Documentation

From: Alex Howansky
Date: 02 February 2001, 15:27:52
Subject: adding not null constraint to existing table

Re: Left Join Complex Query - Mailing list pgsql-general

Previous

Next