Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with group by in conjuction with Views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with group by in conjuction with Views
Date
Msg-id 22488.985882383@sss.pgh.pa.us
Whole thread Raw
In response to Problem with group by in conjuction with Views  (Jeroen Eitjes <Eitjes@WalRas.nl>)
List pgsql-hackers
Tree view 
Jeroen Eitjes <Eitjes@WalRas.nl> writes:
> I have found a small but annoying bug. I have created a view. The
> SQL-statement in the view contains a GROUP BY statement. Then I compose a
> SQL-statement using this view and another GROUP BY statement and a COUNT(*)
> statement.

This sort of thing will not work at all in Postgres releases earlier
than 7.1.  Sorry.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: INSERT/SELECT with ORDER BY and LIMIT in 7.1?
Next
From: Peter Eisentraut
Date:
Subject: Re: Re: Changing the default value of an inherited column