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

From Jeff Davis
Subject Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)
Date
Msg-id 1320122012.23464.4.camel@jdavis
Whole thread Raw
In response to Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)
Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)
List 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.
>
Done.

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
commit:

  * 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.

Regards,
    Jeff Davis


Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql expanded auto
Next
From: Fujii Masao
Date:
Subject: Re: Your review of pg_receivexlog/pg_basebackup