Migrating from 7.1 to 7.2

Hello,

I wrote a plpgsql procedure that returns the executition time of it,
like this:

create procedure myProc() returns time as '
declare
v_start time;
v_end time;
begin
select timeofday()::timestamp::time into v_start;
(do some work)
select timeofday()::timestamp::time into v_end;
return v_end - v_start;
end;' language 'plpgsql'

This worked fine at 7.1, but now, in 7.2.1, isn't working. In 7.1, i
got:

template1=# select timeofday()::time;
ERROR: Bad time external representation 'Wed May 08 17:19:15.389569 2002
BRT'
template1=# select timeofday()::timestamp::time;
?column?
----------
17:19:20
(1 row)

In 7.2.1, i got:

bench=# select timeofday()::time;
ERROR: Bad time external representation 'Wed May 08 17:20:37.891559 2002
BRT'
bench=# select timeofday()::timestamp::time;
ERROR: Cannot cast type 'timestamp with time zone' to 'time without time
zone'

I tried change time zones, date style, etc... but I didn't fix it.

Thanks for any help,

Edipo Elder
[edipoelder(at)ig(dot)com(dot)br]

_________________________________________________________________________
Voc podia estar baixando sua musica predileta, enquanto lia esse e-mail.
No perca tempo, tenha acesso rpido a internet com o Super iG.
http://registro.ig.com.br/superig