Re: [BUGS] BUG #2977: dow doesn't conform to ISO-8601

From: Adriaan van Os <postgres(at)microbizz(dot)nl>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2977: dow doesn't conform to ISO-8601
Date: 2007-02-21 11:06:01
Message-ID: 45DC2799.5060808@microbizz.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Bruce Momjian wrote:
> Updated version applied. I reduced the numering changes for the macros.
>
> There was also documentation text for "dow" and a few others that said
> "(for <type>timestamp</type> values only)", but in fact the field worked
> for "timestamptz" and "date" too, so I removed the mentions. If people
> get confused, I will come up with new wording, like "doesn't work for
> interval or time", which I think is pretty obvious. I remember people
> got confused in the past about this, so maybe we still need something.
>
> ---------------------------------------------------------------------------
>
> Bruce Momjian wrote:
>> I have implemented 'isodow' with the attached patch.

Thanks for the patch and the new function.

Adriaan van Os

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Cedric Scott 2007-02-21 13:18:36 BUG #3046: odbc zip file corrupt
Previous Message Thomas Fromm 2007-02-21 09:36:47 Re: BUG #2973: Compile Error with MIPSpro compiler

Browse pgsql-patches by date

  From Date Subject
Next Message Florian G. Pflug 2007-02-21 13:37:46 Re: tsearch in core patch, for inclusion
Previous Message Markus Schiltknecht 2007-02-21 11:04:47 Re: tsearch in core patch, for inclusion