Casting timestamp - Mailing list pgsql-sql

From Edipo E. F. Melo
Subject Casting timestamp
Date
Msg-id 20020519125527.BF7D14758D7@postgresql.org
Whole thread Raw
Responses Re: Casting timestamp
List pgsql-sql
Hi all, 
I posting this again...
Why the second casting don't work?

--- start with this 
set datestyle = 'iso'; 
show datestyle; 
select current_timestamp::text::timestamp; 
--- now try this 
set datestyle = 'postgres'; 
show datestyle; 
select current_timestamp::text::timestamp; 
   In the first one, I get          timestamptz 
------------------------------- 2002-05-13 10:19:55.158434-03 
   In the last one, I get 
ERROR:  Bad timestamp external representation 'Mon May 13 10:19:56.671847 
2002 BRT' 


   []'s
   Edipo Elder F. de Melo




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL TODO
Next
From: "Joel Burton"
Date:
Subject: Re: Casting timestamp