From: Edipo Elder Fernandes de Melo <edipoelder@ig.com.br>
To: pgsql-sql@postgresql.org
Subject: Migrating from 7.1 to 7.2
Date: Wed, 8 May 2002 17:48:34 -0300
Message-ID: <20020508204834.53EEC475EB0@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: edipoelder@ig.com.br
Subject: Re: Migrating from 7.1 to 7.2
In-Reply-To: <20020508204834.53EEC475EB0@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox