Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How do you live without OUTER joins? - Mailing list pgsql-general

From David Warnock
Subject Re: [GENERAL] How do you live without OUTER joins?
Date
Msg-id 387C663B.96BD362@sundayta.co.uk
Whole thread Raw
In response to How do you live without OUTER joins?  ("Bruce Bantos" <anon@mgfairfax.rr.com>)
Responses Re: [GENERAL] How do you live without OUTER joins?
List pgsql-general
Tree view 
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

Dave

pgsql-general by date:

Previous
From: Shadkam Islam
Date:
Subject: Re: [GENERAL] case-insensitive like operator
Next
From: yura
Date:
Subject: Re[2]: [GENERAL] case-insensitive like operator