Am Mittwoch, 7. Februar 2007 11:24 schrieb Adriaan van Os: > Section 9.9.1 of the Postgres docs > <http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html> > mentions that the "week" subfield of the date_part function conforms to the > ISO-8601 standard.
I see no such claim there. > You can not, in the same function, ignore ISO-8601 for one subfield and > follow it in another. I think we have pretty well shown that we can. > Besides, if in the same week Sunday comes before Monday, how can the result > of the "week" and "dow" fields conform to each other ? They don't. > If "dow" can not be changed for reasons of backward compatibility, I > suggest a new subfield "dayofweek" that does conform to the standard. That might be reasonable. (Or maybe "isodow".) -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
