Dear Gurus,
Sorry for upping a 13-month-old thread; please tell if I should've opened
another one.
Here I come again, with another silly join. Please forgive me, but our
queries are built from blocks :)
VERSION: 7.4.6, 7.4.8, 8.0.0rc4 (sorry, no newer installed right now)
ABSTRACT: The
=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= [EMAIL PROTECTED] writes:
ABSTRACT: The following query fails.
SELECT * FROM
(SELECT a,b FROM cdqp WHERE a=1 AND b=2) AS aa
NATURAL FULL JOIN
(SELECT a,b FROM cdqp WHERE a=1 and b=2) AS bb
WHERE a+b = 3;
Thanks for the
Dear Tom,
I didn't get your replies, but found them in the archives.
Thanks a lot, the patched 7.4 works with the original query!
(didn't patch 7.3 since it's a production db, and it works in 7.3 anyway)
Thanks again,
Yours,
G.
%--- cut here ---%
\end
Dear Gurus,
I couldn't find the string of my email's subject on the web, except for one
place: the PostgreSQL source :)
So I'm desperate.
--
VERSION
I'm using PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
with the patch for shown aggregate columns is 0 (if you know what I mean
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= [EMAIL PROTECTED] writes:
If this is a bug and has been fixed since 7.4.1, I'd take the task to
compile a newer version and see how it fares.
It's still there in CVS tip :-(. Will look into it today.
regards, tom lane
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= [EMAIL PROTECTED] writes:
I couldn't find the string of my email's subject on the web, except for one
place: the PostgreSQL source :)
Seems that you've managed to tickle a strange corner case, which can be
reduced to simplest form like this:
regression=#