Re: nested implicit selects (views) go wrong

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: piotr(dot)sulecki(at)ios(dot)krakow(dot)pl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: nested implicit selects (views) go wrong
Date: 2000-09-11 16:10:32
Message-ID: 14303.968688632@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Yeah, grouped views are pretty flaky --- they work OK in isolation,
but not when you combine them with others. In general the current
implementation of views can't do anything you couldn't do by writing
out the complete computation as a single SQL query. Here that can't
work because you'd need to group/aggregate over different sets of
tuples for the two views. The rewriter not only can't handle this,
but is not bright enough to realize that it's emitting an incorrect
translation.

We hope to fix this and related problems for 7.2. It will take a
wholesale redesign of querytrees to fix all the problems ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Max Pyziur 2000-09-12 03:03:26 Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?
Previous Message Thomas Lockhart 2000-09-11 14:49:30 Re: datestyle