On Thu, 6 Jul 2000, Peter Eisentraut wrote:
> Thomas Lockhart writes:
>
> > I've been pretty resistant to having a fully-tailorable native output
> > capability, since it would be possible to generate date strings which
> > can not be correctly interpreted on input.
>
> Good point. Let them use to_char().
>
Small note, to_char() has good friend to_timestamp() and this second
routine must allow interpret all output from to_char() to PG internal
datetype.
test=# select to_timestamp( to_char( now(), '"perverse date/time: "Y,YYY
FMMonth-DD HH24:MI:SS'), '"perverse date/time: "Y,YYY FMMonth-DD
HH24:MI:SS') = now();?column?
----------t
(1 row)
Karel