Re: Difference between Access97 and PostgreSQL

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!