"Vilson farias" <[EMAIL PROTECTED]> writes: > Is there a way to set a "timestamp compatibility mode" for PostgreSQL > 7.3.3's timestamp with older versions of database (like 7.1.2)? I'd like to > set all timestamps to have precision =3D zero (hh:mm:ss only, without any > millisecond).
Create the timestamp columns as timestamp(0) with time zone regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])