Re: - Mailing list pgsql-hackers

From Jeff Davis
Subject Re:
Date
Msg-id 1320126470.23464.10.camel@jdavis
Whole thread Raw
In response to  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Jeroen Vermeulen
Date:
Subject: Re: Multiple queries in transit
Next
From: Fujii Masao
Date:
Subject: Re: unite recovery.conf and postgresql.conf