Re: outer join syntax - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: outer join syntax
Date
Msg-id Pine.GSO.4.02A.10003311554050.10283-100000@Stork.DoCS.UU.SE
Whole thread Raw
In response to outer join syntax  (Sarfaraz Patel <s.patel@ctc.ucl.ac.uk>)
List pgsql-sql
On Fri, 31 Mar 2000, Sarfaraz Patel wrote:

> Regarding the syntax for outer join.....i try using this for my query...
> select  ran, "pr", "followup"
> from view_pr, view_followup
> where ran.trialno *=* view_pr.trialno and
> ran.trialno *=* view_followup.trialno;

Since when is that the outer join syntax? PostgreSQL 7.0 will have support
for SQL outer join syntax but the actual joining isn't implemented yet.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-sql by date:

Previous
From: Patrik Kudo
Date:
Subject: Re: Novice trouble with plpgsql
Next
From: "Ed"
Date:
Subject: Sub select..