Re: BUG #9896: Bug in FULL OUTER JOIN - Mailing list pgsql-bugs

From David Johnston
Subject Re: BUG #9896: Bug in FULL OUTER JOIN
Date
Msg-id 1396892597266-5799042.post@n5.nabble.com
Whole thread Raw
In response to Re: BUG #9896: Bug in FULL OUTER JOIN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane-2 wrote
> In any case, don't hold your breath waiting for a fix; I'm just asking
> to gather information for possible future work.  This is unlikely to
> be simple to fix, and it's not going to be very high on anyone's priority
> list either, given that few people use FULL JOIN as far as I've heard.

Infrequently, maybe, but especially for dataset comparisons FULL JOIN is
convenient.  That said, typically reformulation of the data and/or query is
possible, even if somewhat slower, so it isn't like getting a result is
impossible given this limitation.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-9896-Bug-in-FULL-OUTER-JOIN-tp5799008p5799042.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres resources not released after call PQclear
Next
From: jeff@jefftrout.com
Date:
Subject: BUG #9898: WindowAgg's causing horrific plans