Re: How to select and result row number??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Roland Roberts <roland(at)astrofoto(dot)org>, Yudie <yudie(at)axiontech(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to select and result row number??
Date: 2002-09-17 15:05:24
Message-ID: 24103.1032275124@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Ross J. Reedstrom" <reedstrm(at)rice(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-09-17 15:29:56 Re: Returning a reference to a cursor from a function
Previous Message Ross J. Reedstrom 2002-09-17 14:46:35 Re: How to select and result row number??