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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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 15:36:44
Message-ID: 20071114153644.GB14099@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 14, 2007 at 10:26:52AM -0500, Tom Lane wrote:
> That's a fairly ugly/messy way of doing it. If you're going to need a C
> function anyway, why not just do it directly? As in the attachment.

actually you dont have to do it in c.
alec pointed (in comments) that there already is statement_timestamp()
function, so you can remove the c code, and use statement_timestamp()
instead of get_statement_timestamp().

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-14 15:44:59 Re: Using generate_series to create a unique ID in a query?
Previous Message Gauthier, Dave 2007-11-14 15:28:30 reserving space in a rec for future update