From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | Darren Duncan <darren(at)darrenduncan(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Generate a dynamic sequence within a query |
Date: | 2010-10-21 23:38:31 |
Message-ID: | 20101021233831.GA6739@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Oct 20, 2010 at 09:35:11PM -0700, Darren Duncan wrote:
- Josh Kupershmidt wrote:
- >On Wed, Oct 20, 2010 at 6:22 PM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:
- >>I know I've seen posts on how to do this, but i can't seem to find them.
- >>
- >>I've got a data set
- >>
- >>A, B
- >>A, C
- >>A, D
- >>[...]
- >>
- >>and so on
- >>
- >>and i'd like to be able to wite a query that would result in
- >>
- >>1,A,B
- >>2,A,C
- >>3,A,D
- >>[...]
- >>
- >>PG version is 8.3.
- >
- >If you can upgrade to 8.4, you could use the row_number() window
- >function which is perfectly suited to this task, should be as simple
- >as:
- >
- >SELECT row_number() OVER (), * FROM tablename;
-
- Yes indeed. For a simple increment by one sequence, functions like rank()
- ... see
- http://www.postgresql.org/docs/9.0/interactive/functions-window.html ...
- are exactly what you want. -- Darren Duncan
Well, an upgrade's not on tap for a few months. Until then i'll need to
figure out somethnig else.
thanks all.
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-10-21 23:42:14 | Re: [GENERAL] Gripe: bytea_output default => data corruption |
Previous Message | ljb | 2010-10-21 23:12:40 | Re: Gripe: bytea_output default => data corruption |