Date: Wed, 8 May 2002 17:48:34 -0300
To: pgsql-sql@postgresql.org
From: Edipo Elder Fernandes de Melo <edipoelder@ig.com.br>
Cc: 
Subject: Migrating from 7.1 to 7.2
Message-Id: <20020508204834.53EEC475EB0@postgresql.org>

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@ig.com.br] 

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