On 1 April 2011 02:35, Marc Munro <marc@xxxxxxxxxxxx> wrote: > Just to be clear, the reason I was mixing things in this way was that I > wanted to validate that the dayname being passed was valid for the > current locale, and I could find no easier way of doing it. Ah, I see. In that case I think to_date would have disappointed you even if IYYY-IW-DY did work, since the inputs do not appear to be checked against the localised versions of the day names. They are only checked against the hard-coded English names. to_date and to_char are asymmetric in this sense -- localisation only happens on the way out. Cheers, BJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
