Re: Date Questions

"Robert Sanford" <rsanford@trefs.com> 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