Skip site navigation (1) Skip section navigation (2)

Re: gettime() - a timeofday() alternative

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Brendan Jurd <direvus(at)gmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: gettime() - a timeofday() alternative
Date: 2005-08-13 02:36:01
Message-ID: 200508130236.j7D2a1s01765@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
This has been saved for the 8.2 release:

	http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

Brendan Jurd wrote:
> 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, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-08-13 02:36:49
Subject: Re: obtaining row locking information
Previous:From: Bruce MomjianDate: 2005-08-13 02:34:08
Subject: Re: gettime() - a timeofday() alternative

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-08-13 02:37:36
Subject: Re: [PATCHES] prevent encoding conversion recursive error
Previous:From: Bruce MomjianDate: 2005-08-13 02:34:08
Subject: Re: gettime() - a timeofday() alternative

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group