From: Bruno Wolff III <bruno@wolff.to>
To: David Garamond <lists@zara.6.isreserved.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: olympics ranking query
Date: Fri, 20 Aug 2004 12:01:48 -0500
Message-ID: <20040820170148.GB26674@wolff.to> (raw)
In-Reply-To: <41262968.2000507@zara.6.isreserved.com>
References: <41262968.2000507@zara.6.isreserved.com>
On Fri, Aug 20, 2004 at 23:40:08 +0700,
David Garamond <lists@zara.6.isreserved.com> wrote:
>
> Challenge question: is there a simpler way to do query #1 (without any
> PL, and if possible without sequences too?
You could use a subselect to count how many countries had a lower
medal ranking and add 1 to get the rank. This should be a lot more standard
than using sequences. It will probably be a little slower, but for tables
of that size it shouldn't be a big deal.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, lists@zara.6.isreserved.com
Subject: Re: olympics ranking query
In-Reply-To: <20040820170148.GB26674@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox