Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8F3D64759D2 for ; Mon, 13 May 2002 03:13:28 -0400 (EDT) Received: from ebewe.com (unknown [80.120.1.196]) by postgresql.org (Postfix) with ESMTP id 39943475960 for ; Mon, 13 May 2002 03:11:59 -0400 (EDT) Received: from exim by ebewe.com with spam-scanned (Exim 4.02) id 17793v-0006Gz-00 for pgsql-sql@postgresql.org; Mon, 13 May 2002 08:11:59 +0200 Received: from horn.intern.ebewe.at ([172.16.5.1] helo=mail.ebewe.co.at) by ebewe.com with esmtp (Exim 4.02) id 17793r-0006Gm-00; Mon, 13 May 2002 08:11:56 +0200 Subject: Re: Migrating from 7.1 to 7.2 To: Edipo Elder Fernandes de Melo Cc: pgsql-sql@postgresql.org, pgsql-sql-owner@postgresql.org X-Mailer: Lotus Notes Release 5.0.9 November 16, 2001 Message-ID: From: Wolfgang.Fuertbauer@ebewe.com Date: Mon, 13 May 2002 09:12:59 +0200 X-MIMETrack: Serialize by Router on Unta_Notes_Srv01/EBEWE/AT(Release 5.0.9a |January 7, 2002) at 13.05.2002 09:13:00 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *17793r-0006Gm-00*6s2OLKpYRPQ* X-Spam-Status: No, hits=0.8 required=5.0 tests=NO_REAL_NAME,AWL version=2.20 X-Spam-Level: X-Archive-Number: 200205/117 X-Sequence-Number: 7753 Why do I get this message about 100 times ? W On 08.05.2002 17:48:34 pgsql-sql-owner wrote: >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=3D# select timeofday()::time; >ERROR: Bad time external representation 'Wed May 08 17:19:15.389569 2002 >BRT' >template1=3D# select timeofday()::timestamp::time; >?column? >---------- >17:19:20 >(1 row) > >In 7.2.1, i got: > >bench=3D# select timeofday()::time; >ERROR: Bad time external representation 'Wed May 08 17:20:37.891559 2002 >BRT' >bench=3D# 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=EA podia estar baixando sua musica predileta, enquanto lia esse e-mail. >N=E3o perca tempo, tenha acesso r=E1pido a internet com o Super iG. >http://registro.ig.com.br/superig > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org