Robert Treat <[EMAIL PROTECTED]> writes: > I'm not concerned about to_date so much as I am that timestamp_in lets you > store values you can't read with timestamp_out.
Your example does not demonstrate any such thing. What it demonstrates is that to_date will let an out-of-range date into the system, not that timestamp_in will. Counterexample: regression=# select '4714-01-27 BC'::timestamp; ERROR: timestamp out of range: "4714-01-27 BC" regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly