Is this deliberate?

usa=# select '1-1-2001'::date;
    date
------------
 2001-01-01
(1 row)

usa=# select '1-1--2001'::date;
    date
------------
 2001-01-01
(1 row)

usa=# select '1-1---2001'::date;
    date
------------
 2001-01-01
(1 row)

usa=# select '1------------------1--------------2001'::date;
    date
------------
 2001-01-01
(1 row)


Chris



Thu, 26 Jun 2003 16:21:02 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
date parsing
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Is this deliberate?
> usa=# select '1-1--2001'::date;
> [works]

The guys who might actually be able to tell you whether it was an
intended behavior are long gone.  But I don't see any particular
problem with it.

			regards, tom lane

Thu, 26 Jun 2003 09:50:18 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: date parsing 