"Robert Sanford" <[EMAIL PROTECTED]> writes: > It appears to me that there is some inconsistency in the date > calculations for my PostgreSQL install (version 8.0 on Win32).
extract(DOW) follows the convention that the week starts on Sunday, but extract(WEEK) uses the ISO convention, which includes weeks starting on Monday. No, it's not super consistent, but hardly anything about date/time conventions is :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend