Re: [HACKERS] Interesting question

[Tom Lane]

Larry Rosenman <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION "nowminus" (interval) RETURNS timestamp with time zone AS 'SELECT 
>now() - $1;' LANGUAGE 'sql';

Right idea, but you need to mark it iscachable.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]