Re: error joining 2 views containing GROUP BYs

From: "david morgan" <david_morgan(at)s4c(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: error joining 2 views containing GROUP BYs
Date: 2001-03-13 15:04:20
Message-ID: 98lctc$31j$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks for your help.
It runs blindlingly fast under beta5 so I'll keep my fingers crossed and
hope it will be stable enough!

Tom Lane wrote in message <17919(dot)984457255(at)sss(dot)pgh(dot)pa(dot)us>...
>"david morgan" <david_morgan(at)s4c(dot)co(dot)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 :-(.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Poole 2001-03-13 15:07:52 Re: Re: Use of the LIMIT clause ?
Previous Message Tom Lane 2001-03-13 15:04:12 Re: != and <> operators