Re: checking date format with postgresql without creating

On Mon, 19 Nov 2001, Neil Zanella wrote:

> Hello,
>
> I would like to be able to check whether some date is a valid date by
> asking postgresql? Is this possible?

Sure:

alvherre=> select '28 feb 2001'::date;
date
------------
2001-02-28
(1 row)

alvherre=> select '29 feb 2001'::date;
ERROR: Bad date external representation '29 feb 2001'

You don't need a table to do it.

--
Alvaro Herrera (<alvherre[(at)]atentus(dot)com>)