Hi to all,
I did a funciont for retrieve the actual time stamp
(not the time stamp of transaction):
CREATE FUNCTION sp_now ( )
RETURNS timestamp AS'
DECLARE
BEGIN
RAISE NOTICE ''sp_now()'';
RETURN timestamp(timeofday());
END;
' LANGUAGE 'plpgsql';
I notice that when I do some select l
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> It is normal that inside sp_foo() the sp_now() is not anymore called ?
You *did* mark it cachable. timeofday() is pretty much the classic
example of functions that shouldn't be marked cachable.
regards, tom lane
--
"Tom Lane" <[EMAIL PROTECTED]> wrote:
> "Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> > It is normal that inside sp_foo() the sp_now() is not anymore called ?
>
> You *did* mark it cachable. timeofday() is pretty much the classic
> example of functions that shouldn't be marked cachable.
Yes I
Is there a howto/demo/tutorial for setting up replication with Postgres 7.2?
Thanks
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html