Re: Range Types - symmetric

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Range Types - symmetric
Date: 2011-09-25 18:30:54
Message-ID: 1316975454.7281.234.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 2011-09-24 at 10:49 -0400, Bruce Momjian wrote:
> > I'll add that it would also cause a little confusion with inclusivity.
> > What if you do: '[5,2)'::int4range? Is that really '[2,5)' or '(2,5]'?
>
> Reminder: BETWEEEN supports the SYMMETRIC keyword, so there is
> a precedent for this.

And I don't see it as valuable enough to justify changing the grammar.

Also, that still leaves confusion about inclusivity when applied to
range types.

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Berkus 2011-09-25 18:39:42 Re: unite recovery.conf and postgresql.conf
Previous Message Tom Lane 2011-09-25 18:05:29 Re: unite recovery.conf and postgresql.conf