Re: Using generate_series to create a unique ID in a query?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jan de Visser" <jdevisser(at)digitalfairway(dot)com>
Cc: depesz(at)depesz(dot)com, "Sarah Dougherty" <sdougherty(at)desc(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Using generate_series to create a unique ID in a query?
Date: 2007-11-14 16:34:37
Message-ID: 24842.1195058077@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jan de Visser" <jdevisser(at)digitalfairway(dot)com> writes:
> Any reason why this couldn't appear in the core of some future
> version?

You didn't read to the end of my post ;-). If a rownum() function
like this didn't have any gotchas, I'd be in favor of putting it in,
but I don't really want to set the behavior in stone just yet.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan de Visser 2007-11-14 16:42:22 Re: Using generate_series to create a unique ID in a query?
Previous Message Gauthier, Dave 2007-11-14 16:31:11 Re: reserving space in a rec for future update