Re: [GENERAL] How do you live without OUTER joins?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: David Warnock <david(at)sundayta(dot)co(dot)uk>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] How do you live without OUTER joins?
Date: 2000-01-12 14:16:58
Message-ID: 200001121416.JAA26143@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Bruce,
>
> Can't a sub select do this (mind you not sure if PostgreSQL supports sub
> selects)?
>
> eg
>
> select company_name, (select com_cat_long from company_category cat
> where cat.com_cat_abbr = cpy.com_cat_abbr) from company cpy
>

Only 7.0 will support subselects in the target list. 6.5.* only
supports them in the WHERE clause.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-01-12 14:19:21 Re: [GENERAL] query with LIKE
Previous Message Nina Kuznetsova 2000-01-12 13:20:08 query with LIKE