ement)".
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Jean-Pierre Pelletier" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, October 25, 2005 4:34 PM
Subject: Re: [BUGS] RIGHT JOIN is only supported with merge-joinable join
conditions, PostgreSQL 8.1
"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> writes:
> select
>count(table3.*)
> from
>table1
>inner join table2
>on table1.t1id = table2.t1id
>and table1.extension in (table2.original, table2.replacement)
>left outer join table3
>on table2.t3id = table3.t3id
>and tab
"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> 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
--
Hi,
I have a query that throws error "RIGHT JOIN is only supported with
merge-joinable join conditions".
This should allow it to be reproduce.
create table table1 (t1id integer not null, extension integer not null);
create table table2 (t1id integer not null, t3id integer not null, original
i