[HACKERS] to_date_valid()

[Andreas 'ads' Scherbaum]

Hello,



http://sql-info.de/postgresql/notes/to_date-to_timestamp-gotchas.html





--
                                Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project

we have customers complaining that to_date() accepts invalid dates, and returns a different date instead. This is a known issue: On the other hand this leads to wrong dates when loading dates into the database, because the database happily accepts invalid dates and ends up writing something completely different into the table. The attached patch adds a new function "to_date_valid()" which will validate the date and return an error if the input and output date do not match. Tests included, documentation update as well.

to_date_valid.patch.gz
Description: application/gzip

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers