Re: RIGHT JOIN is only supported with mergejoinable join conditions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "PGSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: RIGHT JOIN is only supported with mergejoinable join conditions
Date: 2001-11-07 17:38:43
Message-ID: 5273.1005154723@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

"Nick Fankhauser" <nickf(at)ontko(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-11-07 17:57:32 Re: performance problem with 3-column indexes
Previous Message Peter Eisentraut 2001-11-07 17:28:24 Re: Beta going well

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-07 18:06:36 Re: Need help with embedded CASEs
Previous Message qradius 2001-11-07 17:37:16 help with function and quotes