Hi, I would like to start a discussion for a solution regarding this item.
At this moment these functions only accept English month/day names due formatting.c:172:months_full[] and datetime.c:53-58 months[], days[]. The values are predetermined. (hardcoded sounds bahhh...) What do we think about a solution that would be like: 1. Add an extra (optional) parameter to to_date and to_timestamp which would indicate the locale we are trying to parse. For example to_date('10 okt 2008','DD Mon YYYY','nl-NL') 2. If the third parameter exists, read the month/day names for a list of some kind. 3. Pass the list to formatting.c:1615:seq_search to parse the string with these localized names list. My questions: Is step 1 acceptable/correct to start with? If yes, what would you recommend for step 2? Regards, Gevik Babakhani ------------------------------------------------ PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ------------------------------------------------ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings