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]
