Re: Left Joins - Mailing list pgsql-admin

From David Stanaway
Subject Re: Left Joins
Date
Msg-id 200109172355.f8HNtWd14098@postgresql.org
Whole thread Raw
In response to Left Joins  (Francisco Eriko Barreto Brito <eriko@radix.com.br>)
List pgsql-admin
On Tuesday, September 18, 2001, at 06:23  AM, Francisco Eriko Barreto
Brito wrote:

> How can I use LEFT JOINS with postgresql?
>
> Is there a command to do LEFT JOINS with postgresql?
>

Upgrade to 7.1 (7.1.3 is the latest I think)
this allows you to use syntax like:

SELECT y.bar, x.foo
FROM tbly y
LEFT JOIN tblx x ON x.id = y.xid


==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Left Joins
Next
From: Morgan Curley
Date:
Subject: postmaster pid and ps