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)

after all, it's also:

select '0001-10-29 BC'::date;
date
---------------
0001-10-29 BC
(1 row)

without double quotes. It's not important, perhaps; it just looks ugly to me.

Do they serve a purpose?

Erik Rijkers

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