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

From: "Jan de Visser" <jdevisser(at)digitalfairway(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:42:22
Message-ID: 1159c1e90711140842h3297c96au1d726948cd3be847@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/14/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "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.

<g> That's me, the ADHD getting the better off.... Oh look, waffles!

:)

jan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Charnoky 2007-11-14 16:44:55 Re: reserving space in a rec for future update
Previous Message Tom Lane 2007-11-14 16:34:37 Re: Using generate_series to create a unique ID in a query?