Re: DATE type output does not follow datestyle parameter

From: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
> Actually the relevant code seems to be here:
>
> /src/ backend/parser/gram.y
>
>
> CURRENT_DATE
> {
> /*
> * Translate as
> "'now'::text::date".
> *
> ....
>
> CURRENT_TIMESTAMP
> {
> /*
> * Translate as "now()", since
> we have a function that
> * does exactly what is needed.
> ...
>
>
> Also from :
>
> 8.5.1.4. Special Values
>
> The following SQL-compatible functions can also be used to obtain the
> current time value for the corresponding data type: CURRENT_DATE,
> CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP. The latter
> four accept an optional subsecond precision specification. (See Section
> 9.9.4.) Note that these are SQL functions and are not recognized in data
> input strings.
>
>
>
> It would seem the functions are special cased.

As below, normal DATE constants also does not follow the setting of
datestyle. Is this a bug?

SET datestyle = 'Postgres, MDY';
SELECT DATE 'Jan 2 2013';
date
------------
01-02-2013
(1 row)

Regards
MauMau