public inbox for [email protected]  

help / color / mirror / Atom feed

From: Grzegorz Szpetkowski <[email protected]>
To: [email protected]
Subject: 7.2. Table Expressions FULL join is only supported with merge-joinable join conditions
Date: Tue, 17 May 2011 01:32:04 +0200
Message-ID: <[email protected]> (raw)

http://www.postgresql.org/docs/9.0/static/queries-table-expressions.html

"The join condition specified with ON can also contain conditions that
do not relate directly to the join. This can prove useful for some
queries but needs to be thought out carefully. For example:

=> SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num AND t2.value = 'xxx';"

Can you add information about FULL JOIN in doc there ? I am trying to
run such query:

SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num AND t2.value = 'xxx';
ERROR:  FULL JOIN is only supported with merge-joinable join conditions

I mean add something like: "Note that you can't use such conditions
with FULL JOIN, only equality of selected columns is supported with
this type".

Thanks,
Grzegorz Szpetkowski

view thread (3+ messages)  latest in thread

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: [email protected]
  Cc: [email protected]
  Subject: Re: 7.2. Table Expressions FULL join is only supported with merge-joinable join conditions
  In-Reply-To: <[email protected]>

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

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