Postgres Pro
Downloads
Home   >   mailing lists

Re: RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3
Date
Msg-id 18760.1130264168@sss.pgh.pa.us
Whole thread Raw
In response to RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3  ("Jean-Pierre Pelletier" <pelletier_32@sympatico.ca>)
List pgsql-bugs
Tree view 
"Jean-Pierre Pelletier" <pelletier_32@sympatico.ca> writes:
> I have a query that throws error "RIGHT JOIN is only supported with
> merge-joinable join conditions".

Wow, that's a goodie ... seems to fail all the way back to 7.2 ...
thanks for the report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: "Jean-Pierre Pelletier"
Date:
Subject: Variable not found in subplan target lists, PostgreSQL 8.1 beta3