Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between Access97 and PostgreSQL - Mailing list pgsql-sql

From Roberto Mello
Subject Re: Difference between Access97 and PostgreSQL
Date
Msg-id 20020131153103.GA14401@cc.usu.edu
Whole thread Raw
In response to Difference between Access97 and PostgreSQL  ("Yan Bai" <annie_job@hotmail.com>)
Responses Re: Difference between Access97 and PostgreSQL
List pgsql-sql
Tree view 
On Wed, Jan 30, 2002 at 11:54:56PM +0000, Yan Bai wrote:
> 
> --------------------------------------------------
> SELECT temp.rating, temp.avgage
> FROM (SELECT s.rating, AVG(s.age) as avgage
>      FROM sailors s GROUP BY s.rating) as temp

Have you tried this query without the subselect? It looks like it should
work.

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net/      http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
 
It said "Insert disk #3", but only 2 will fit!

pgsql-sql by date:

Previous
From: Tod McQuillin
Date:
Subject: Re: How to merge several attributes and Delete an attribute
Next
From: "Radu-Adrian Popescu"
Date:
Subject: Regression tests failed on 7.2rc2