Re: error joining 2 views containing GROUP BYs - Mailing list pgsql-sql

From Tom Lane
Subject Re: error joining 2 views containing GROUP BYs
Date
Msg-id 17919.984457255@sss.pgh.pa.us
Whole thread Raw
In response to error joining 2 views containing GROUP BYs  ("david morgan" <david_morgan@s4c.co.uk>)
List pgsql-sql
"david morgan" <david_morgan@s4c.co.uk> writes:
>     I am having a few problems using a select query which joins two views
> containing aggregate functions (see query 1 below).

I don't think there's any chance of making that work in pre-7.1
Postgres.  Sorry :-(.

As a workaround, consider selecting the grouped data into temp tables
and then joining the temp tables.
        regards, tom lane


pgsql-sql by date:

Previous
From: Cliff Crawford
Date:
Subject: Re: SQL Dummy Needs Help
Next
From: Patrik Kudo
Date:
Subject: != and <> operators