Re: Left Joins

From: David Stanaway <david(at)netventures(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Left Joins
Date: 2001-09-17 23:56:41
Message-ID: 200109172355.f8HNtWd14098@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)stanaway(dot)net
Work: david(at)netventures(dot)com(dot)au

In response to

  • Left Joins at 2001-09-17 20:23:47 from Francisco Eriko Barreto Brito

Browse pgsql-admin by date

  From Date Subject
Next Message Morgan Curley 2001-09-18 03:24:18 postmaster pid and ps
Previous Message Peter Eisentraut 2001-09-17 22:54:11 Re: Left Joins