Hi all, I have changed the host I run PostgreSQL using pg_dump to move
the data.
Is there any issue related to datastyle or locales and pg_dump ??
I think that all dates on my columns got modified some how !
I used to make a query like 

set datestyle 'sql,european'; select * from mytbl where date <
'dd/mm/yyyy';
but that's not working anymore because I'm getting a 
PostgreSQL Error: 1 (ERROR: Bad date external representation
'08/18/2001' )

please help !

-- 
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
begin:vcard 
n:Saad Cruz;Leandro
x-mozilla-html:FALSE
org:Inter Business;IT
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
x-mozilla-cpt:;0
fn:Leandro Saad Cruz
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to