Re: Freezing localtimestamp and other time function on some value

It is not possible in Postgres

PostgreSQL solution is using working time as function parameter. This parameter can have default value.

postgres=# select test('2016-03-10 10:00:00');

NOTICE:  current time is: 2016-03-10 10:00:00

postgres=# select test();
NOTICE:  current time is: 2016-04-12 13:47:21.644488

postgres=# select test();
NOTICE:  current time is: 2016-04-12 13:47:22.633711

CREATE OR REPLACE FUNCTION public.test(t timestamp without time zone DEFAULT now())
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
  RAISE NOTICE 'current time is: %', t;
END;
$function$

Regards

Pavel