Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)
Date: 2011-11-01 04:33:32
Message-ID: 1320122012.23464.4.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 2011-10-24 at 15:05 +0400, Alexander Korotkov wrote:

> I think implementing subtype_diff for each datatype is ok. We could
> implement some universal function based on minus operator and casting
> to double precision. But such solution might be unacceptable in
> both predictability (operator and casting function might do not the
> things we expect) and performance.

Everything is complete in this patch with the exception of two optional
things, which I still intend to do but might best be done in a separate

* support typmod for ranges
* support casts between different range types

Both of these things, I believe, require the introduction of an
RangeCoerceExpr, similar to ArrayCoerceExpr. That's fine, but it creates
a rather large diff, so it might be best left for a later commit.

Jeff Davis

Attachment Content-Type Size
rangetypes-20111101.gz application/x-gzip 49.5 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2011-11-01 04:53:05 Re: Your review of pg_receivexlog/pg_basebackup
Previous Message Peter Eisentraut 2011-11-01 04:22:47 Re: psql expanded auto