| From: | Brendan Jurd <direvus(at)gmail(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: gettime() - a timeofday() alternative |
| Date: | 2005-08-08 08:16:30 |
| Message-ID: | 37ed240d05080801166be4bd39@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On 8/7/05, Brendan Jurd <direvus(at)gmail(dot)com> wrote:
> Hi all,
>
> I propose to add an internal function gettime() that transparently
> returns the current system time, as a timestamptz with maximum
> precision.
>
Here's the patch.
The changes to pg_proc.h, timestamp.h and timestamp.c are trivial.
The changes to func.sgml are more comprehensive; I've split the
section on Current Date/Time into two subsections, one that explains
the transaction time functions and one for the system time functions.
--
BJ
| Attachment | Content-Type | Size |
|---|---|---|
| timestamp.h.diff | application/octet-stream | 601 bytes |
| pg_proc.h.diff | application/octet-stream | 1.0 KB |
| timestamp.c.diff | application/octet-stream | 620 bytes |
| func.sgml.diff | application/octet-stream | 11.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Woodward | 2005-08-08 12:56:13 | Re: shrinking the postgresql.conf |
| Previous Message | Tatsuo Ishii | 2005-08-08 07:52:14 | Re: obtaining row locking information |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-08-08 13:30:38 | Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items) |
| Previous Message | Satoshi Nagayasu | 2005-08-08 05:13:28 | Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items) |