Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select and result row number?? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How to select and result row number??
Date
Msg-id 24103.1032275124@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to select and result row number??  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-sql
Tree view 
"Ross J. Reedstrom" <reedstrm@rice.edu> writes:
> Hmm, with the new dependency code, is the auto-sequence from a SERIAL
> in a temp table also a temp sequence? It get's put in the temp schema,
> right? Seems we have a workaround for those wanting numbered result
> sets.

That's the hard way; just do CREATE TEMP SEQUENCE ... works in prior
releases too ...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: How to select and result row number??
Next
From: Richard Huxton
Date:
Subject: Re: Returning a reference to a cursor from a function