Date validation? - Mailing list pgsql-sql

Folks,

Is there any PgSQL or PL/pgSQL function which validates dates?  I've
tried ISFINITE and CAST ... AS DATE but these suffer fatal errors if the
date isn't valid (e.g. '2001-06-31').  I need a test I can trap inside a
PL/pgSQL function.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco