The IYYY mess again

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-docs(at)postgreSQL(dot)org
Subject: The IYYY mess again
Date: 2014-12-29 15:06:09
Message-ID: 5888.1419865569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

In bug #12367
http://www.postgresql.org/message-id/20141229031218.8013.51171@wrigleys.postgresql.org
we see yet another iteration of somebody trying to combine to_char's
IYYY specifier with regular Gregorian MM/DD fields.

It occurs to me that this is largely our own fault, because the fine
manual just defines IYYY as "ISO year". I'm sure the typical newbie
thought process is "that sounds like a standard year, I'll use that".
There is a warning against combining IYYY with MM/DD, but it's buried
in trivia far down the page.

I did a bit of googling and came across
http://en.wikipedia.org/wiki/ISO_week_date
in which this construct is called an "ISO week-numbering year".

Not having a copy of ISO 8601, I'm not sure if that's the standard's
terminology; but ISTM that if we consistently referred to the Ixxx
format specifiers as "ISO week-numbering foo" then this type of error
might become a little less attractive.

Objections, better ideas?

regards, tom lane

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Steve Atkins 2014-12-29 17:13:33 Re: The IYYY mess again
Previous Message Tom Lane 2014-12-21 20:35:36 Re: Add Optional Variadic Invocation Explanation to 35.4.5 (xfunc-sql)