On Sat, 2011-10-29 at 21:12 +0200, Erik Rijkers wrote:
> Would it be possible to remove of the double quotes in the daterange display of BC dates?
>
> select '[0001-10-29 BC,2011-10-29)'::daterange;
> daterange
> ------------------------------
> ["0001-10-29 BC",2011-10-29)
> (1 row)
It accepts values without quotes, but on output it quotes them similar
to a record type.
Try:
create table foo(d date); select '(0001-10-29 BC)'::foo;
The spaces are the only reason it's being quoted there. I think it's
best to be fairly consistent, and it was suggested that I model the
input parsing after the record parsing.
Regards,Jeff Davis