From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Edipo Elder Fernandes de Melo" <edipoelder(at)ig(dot)com(dot)br>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Migrating from 7.1 to 7.2 |
Date: | 2002-05-09 01:50:36 |
Message-ID: | GNELIHDDFBOCMGBFGEFOIEIHCCAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
How about if you replace ::timestamp:: with ::timestamp(0):: ?
Timestamps in 7.2 have millisecond information included.
Chris
> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Edipo Elder
> Fernandes de Melo
> Sent: Thursday, 9 May 2002 4:49 AM
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] 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.
> Não perca tempo, tenha acesso rápido a internet com o Super iG.
> http://registro.ig.com.br/superig
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2002-05-09 04:24:52 | Re: Performance issues with compaq server |
Previous Message | Ian Barwick | 2002-05-08 23:13:22 | Re: having trouble w/ having clause... |