Postgres Pro
Downloads
Home   >   mailing lists

Re: Using generate_series to create a unique ID in a query? - Mailing list pgsql-general

From Tom Lane
Subject Re: Using generate_series to create a unique ID in a query?
Date
Msg-id 24842.1195058077@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using generate_series to create a unique ID in a query?  ("Jan de Visser" <jdevisser@digitalfairway.com>)
Responses Re: Using generate_series to create a unique ID in a query?  ("Jan de Visser" <jdevisser@digitalfairway.com>)
List pgsql-general
Tree view 
"Jan de Visser" <jdevisser@digitalfairway.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

pgsql-general by date:

Previous
From: "Jan de Visser"
Date:
Subject: Re: Using generate_series to create a unique ID in a query?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: reserving space in a rec for future update