A minor feature request:

PostgreSQL supports ISO-8601 week numbers with the syntax EXTRACT(WEEK FROM
timestamp) or TO_CHAR(timestamp,'IW'). There is, however, no easy way to
extract the year corresponding to the week number.

Since ISO weeks may overlap year boundaries, this makes the week number
functionality nearly unusable in aggregate queries. (e.g. both EXTRACT(WEEK
FROM timestamp '2002-01-01') and EXTRACT(WEEK FROM timestamp '2002-12-31')
returns 1.)

A way to extract the year-of-week would make the extract(week from
date)-functionality a lot more useful.

Brage Førland

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to