pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Dan Langille <dan@langille.org>
To: Marko Asplund <aspa@kronodoc.fi>
Cc: pgsql-sql@postgresql.org
Subject: Re: Oracle outer join porting question
Date: Wed, 15 Jan 2003 10:01:45 -0500
Message-ID: <3E253189.3484.2EE06930@localhost> (raw)
In-Reply-To: <81132473206F3A46A72BD6116E1A06AE3EC030@black.aprote.com>

On 15 Jan 2003 at 16:40, Tambet Matiisen wrote:

> Try this:
> 
> SELECT doc.id,doc.title,sub.user_id,sub.operation
>   FROM document doc LEFT OUTER JOIN document_subscription sub
>   ON sub.document_id = doc.id AND sub.user_id = 6; 

FWIW:

test=# SELECT doc.id,doc.title,sub.user_id,sub.operation
test-#   FROM document doc LEFT OUTER JOIN document_subscription sub
test-#   ON sub.document_id = doc.id AND sub.user_id = 6;
 id | title | user_id | operation
----+-------+---------+-----------
  1 | doc1  |         |
  2 | doc2  |       6 | op2
  4 | doc4  |         |
-- 
Dan Langille : http://www.langille.org/




view thread (5+ messages)  latest in thread

Message-ID: <3E253189.3484.2EE06930@localhost>
Permalink:  ../3E253189.3484.2EE06930@localhost/
Also on:    postgresql.org/message-id/3E253189.3484.2EE06930@localhost

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dan@langille.org, aspa@kronodoc.fi
  Subject: Re: Oracle outer join porting question
  In-Reply-To: <3E253189.3484.2EE06930@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox