=?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
al Message-
From: [EMAIL PROTECTED]
Sent: Tue, 24 May 2005 12:39:04 +0200
To: pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] could not devise a query plan
Dear Gurus,
Sorry for upping a 13-month-old thread; please tell if I should've opened
another one.
Here I come agai
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 fol
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
---
"=?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=#
"=?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
---
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 me
