timestamp/function question - Mailing list pgsql-general

From Soma Interesting
Subject timestamp/function question
Date
Msg-id 5.0.2.1.0.20010328215412.026df008@pop.telus.net
Whole thread Raw
Responses Re: timestamp/function question  (will trillich <will@serensoft.com>)
Re: timestamp/function question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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 '
    BEGIN
        RETURN date_part(''epoch'', CURRENT_DATE);
    END;
' LANGUAGE 'plpgsql';


pgsql-general by date:

Previous
From: Marc Wrubleski
Date:
Subject: Re: Determine Time in other Time Zone
Next
From: Pruner Jan
Date:
Subject: RE: Re: Patch (tiny): \cd (change dir) for psql.