Re: Functions with COPY

Stephen Frost <sfrost@snowman.net> writes:
>   Consider the following input data:
>   1234,24.50,10-Jan-2003,10/1/03,10-01-2003,hiall

>   The interpretation for the numbers is:
>   1234 =3D 12.34, 24.50 =3D 24.50
>   The interpretation for the dates is:
>   January 10th, 2003, October 1st, 2003, October 1st, 2003

>   I don't believe it's possible, currently, to correctly import this
>   data with copy.  I'm not sure the date fields would even be accepted
>   as date fields.

Nonsense.

regression=# set datestyle to mdy;
SET
regression=# select '10-Jan-2003'::date;   date
------------2003-01-10
(1 row)

regression=# select '10/1/03'::date;   date
------------2003-10-01
(1 row)

regression=# select '10-01-2003'::date;   date
------------2003-10-01
(1 row)

I think you'd have to do some preprocessing on the numeric inputs if you
wanted implied decimal points inserted like that, but the dates look fine.
        regards, tom lane