Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group