Thread:

From
"Erik Rijkers"
Date:
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








Re:

From
Jeff Davis
Date:
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