Re: outer join syntax

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Sarfaraz Patel <s(dot)patel(at)ctc(dot)ucl(dot)ac(dot)uk>
Cc: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: outer join syntax
Date: 2000-03-31 13:55:20
Message-ID: Pine.GSO.4.02A.10003311554050.10283-100000@Stork.DoCS.UU.SE
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ed 2000-03-31 21:11:13 Sub select..
Previous Message Patrik Kudo 2000-03-31 12:59:51 Re: Novice trouble with plpgsql