| 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: | Postg토토 커뮤니티SQL |
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)
| 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 |