From: | Dennis Kaarsemaker <fake_adress(at)use-reply(dot)to> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Calculating with sql |
Date: | 2002-06-26 20:18:07 |
Message-ID: | afdeiv.214.1@kaarsemaker.nb.nu |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I'm having trouble figuring out how to select something.
This is the problem:
From a copy of the CDDB-database i want to select the artist & album that
has on average the longest tracks.
But in the tracks table there is no such field as length, so i have to
calculate it. But when i try to do so it just gives me errors.
This is the erroneous query i have made so far
select albums.ARTIST, albums.TITLE from tracks,albums
where tracks.DISCID = albums.DISCID
group by tracks.DISCID
having(albums.LENGTH/count(tracks.TRACK)) =
(
select max(albums.LENGTH/count(tracks.TRACK)) from tracks,albums
where tracks.DISCID = albums.DISCID
group by tracks.DISCID
);
What is the correct way of selecting the album?
--
Dennis K.
~.. It is impossible to make anything foolproof,
.>>. because fools are so ingenious -Roger Berg-
|\
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-26 22:59:04 | Re: Possibility of Index-Only access in PostgreSQL? |
Previous Message | Josh Berkus | 2002-06-26 18:12:02 | Re: Limiting database size |