No title
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