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

Re: pl/pgsql and returns timestamp type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Terry Yapt <yapt(at)technovell(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: pl/pgsql and returns timestamp type
Date: 2002-09-10 19:27:29
Message-ID: 21392.1031686049@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> But then... How could I obtain "variable global values" (like the timestamp 
>> for example) in different function locations whit its "at time" values ???

> Not that I know of.   I'd suggest, instead, that you call the second now() 
> statement after the function completes.

There is a function that gives true realtime, rather than transaction
start time as now() does.  I think it's called timeofday(), but check
the manual.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Roland RobertsDate: 2002-09-10 20:40:44
Subject: Unique indices and nulls
Previous:From: Josh BerkusDate: 2002-09-10 18:12:59
Subject: Re: pl/pgsql and returns timestamp type

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