Re: Difference between Access97 and PostgreSQL

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Yan Bai <annie_job(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Difference between Access97 and PostgreSQL
Date: 2002-01-31 15:31:03
Message-ID: 20020131153103.GA14401@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Radu-Adrian Popescu 2002-01-31 15:36:38 Regression tests failed on 7.2rc2
Previous Message Tomas Eriksson 2002-01-31 13:58:04 compare with CHAR