Soma Interesting <dfunct(at)telus(dot)net> writes:
> Why does the following code return the exact same value each time, instead
> of a value based on the current time?
> CREATE FUNCTION memb_num () RETURNS INT4 AS '
> RETURN date_part(''epoch'', CURRENT_DATE);
> ' LANGUAGE 'plpgsql';
Because you asked for a value based on the current *date*.
If you waited till tomorrow and tried again, then you'd get a
different answer. Perhaps you want
RETURN date_part(''epoch'', CURRENT_TIMESTAMP);
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2001-03-29 16:00:39|
|Subject: Re: Pgsql-7.1RC1: SET SEED = <something> |
|Previous:||From: chris markiewicz||Date: 2001-03-29 15:46:21|
|Subject: ExecSQL NullPtrEx...conn timeout?|