Re: [GENERAL] default value problem in postgresql 7.4.5-2

2004-09-23 Thread Tom Lane
Frans <[EMAIL PROTECTED]> writes: > I set the default value to '1900-01-01 00:00:00' , but the result is >'1900-01-01 00:00:00'::timestamp without time zone Why is this a problem? regards, tom lane ---(end of broadcast)

[GENERAL] default value problem in postgresql 7.4.5-2

2004-09-23 Thread Frans
Hello All, I have just upgrade my postgresql to 7.4.5-2, but I have problem with default value in postgresql 7.4.5-2, everytime I set default value for varchar or timestamp fields, the result value always change to sometihing like this : I set the default value to '1900-01-01 00:00:00' , but the r