Re: outer join question

#1

Oops,

Please forget about this, the mail wasn't finished yet.

Sorry,

-> Maximilian Tyrtania | Mty (AT) fischerAppelt (DOT) de
fischerAppelt Kommunikation GmbH
Tucholskystr. 18 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de
--

Quote:

Von: Maximilian Tyrtania <Mty (AT) Fischerappelt (DOT) de
Datum: Mon, 05 Jan 2004 11:20:01 +0100
An: <pgsql-novice (AT) postgresql (DOT) org
Betreff: outer join question

Folks,

I'm using Openbase and in general I'm quite happy with it, but lately some
strange behaviour with outer joins have made me look at alternatives.

I basically wnat to know how Postgresql handles the following situation:

Scenario:
a company table, a people table and a field company_id in the people table.
Nothing too exotic so far.

Select people.firstname, people.lastname, company.name from people,company
where people.company_id=company.company_id

-> Maximilian Tyrtania | Mty (AT) fischerAppelt (DOT) de
fischerAppelt Kommunikation GmbH
Tucholskystr. 18 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de
--

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: outer join question

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: outer join question - 01-05-2004 , 11:04 AM