timestamp and datestyles

Hi all,

Why this is different?

--- 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'

Abracos,

Edipo Elder
[edipoelder(at)ig(dot)com(dot)br]

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