Postgres Pro
Downloads
Home   >   mailing lists

Re: RIGHT JOIN is only supported with mergejoinable join conditions - Mailing list pgsql-sql

From Tom Lane
Subject Re: RIGHT JOIN is only supported with mergejoinable join conditions
Date
Msg-id 5273.1005154723@sss.pgh.pa.us
Whole thread Raw
In response to RIGHT JOIN is only supported with mergejoinable join conditions  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: RIGHT JOIN is only supported with mergejoinable join conditions  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-sql
Tree view 
"Nick Fankhauser" <nickf@ontko.com> writes:
> I'm on version 7.1, and I'm getting this error when attempting to select
> from a view:
> RIGHT JOIN is only supported with mergejoinable join conditions

What are the datatypes of the columns you're using?
        regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Need help with embedded CASEs
Next
From: Tom Lane
Date:
Subject: Re: Need help with embedded CASEs