Re:

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re:
Date: 2011-11-01 05:47:50
Message-ID: 1320126470.23464.10.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • at 2011-10-29 19:12:22 from Erik Rijkers

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2011-11-01 05:59:50 Re: unite recovery.conf and postgresql.conf
Previous Message Jeroen Vermeulen 2011-11-01 04:58:54 Re: Multiple queries in transit