row numbering

From: Detlef Jockheck <detlef(at)jockheck(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: row numbering
Date: 2003-03-06 20:19:18
Message-ID: 200303062019.h26KJIW04397@krakatau.jockheck.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

How can I number the rows. I have a table with one column:
a
44.3
2.3
33.2
17

Now I need a reverse numbered table:
a points
2.3 4
17 3
33.2 2
44.3 1

I've seen that this is possible with a sequence, but then I alwas have to
create, use and drop it for every query. Is there a better way available?

ciao
Detlef

--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef(at)jockheck(dot)de
# -------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2003-03-06 20:28:59 sub select madness
Previous Message Bruce Momjian 2003-03-06 20:07:49 Re: triggers