"Rod Taylor" <rod.taylor@gmail.com> writes:
> DECLARE
> v_time timestamp_with_precision;
> BEGIN
> SELECT (CURRENT_DATE, 'day')::timestamp_with_precision
> INTO v_time;
You're overthinking the problem, it should just read
SELECT CURRENT_DATE, 'day'
INTO v_time;
regards, tom lane