Re: BUG #14605: round trip of day of week doesn't work

On Wed, Mar 29, 2017 at 11:36 PM, <shaunc(at)factfiber(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14605
> Logged by: Shaun Cutts
> Email address: shaunc(at)factfiber(dot)com
> PostgreSQL version: 9.6.0
> Operating system: MAC OS
> Description:

Seems someone hasn't been doing his homework.

> select extract(dow from to_date('Monday', 'Day'));
> date_part
> -----------
> 6
> (1 row)
> # select extract(dow from to_date('Sunday', 'Day'));
> date_part
> -----------
> 6
> (1 row)

Have you thought on trying and pasting in your report the results of

select to_date('Monday', 'Day');
select to_date('Sunday', 'Day');

Because at least in my machine:

# select version(), to_date('Monday','day') as Monday,
to_date('Sunday','day') as Sunday;
-[ RECORD 1 ]-------
version | PostgreSQL 9.3.10 ....snipped...
monday | 0001-01-01 BC
sunday | 0001-01-01 BC

Due to the version mismatch I cannot state 'not a bug', but me ( and
possibly other more knoledgeable people ) could consider looking at it
further if you had tested the parts. Divide et impera.

Francisco Olarte.