Re: patch for between symmetric, asymmetric (from TODO) - Mailing list pgsql-patches

From Tom Lane
Subject Re: patch for between symmetric, asymmetric (from TODO)
Date
Msg-id 14179.1117638888@sss.pgh.pa.us
Whole thread Raw
In response to patch for between symmetric, asymmetric (from TODO)  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Responses Re: patch for between symmetric, asymmetric (from TODO)  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-patches
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
>     I did task from TODO: Add BETWEEN ASYMMETRIC/SYMMETRIC.
> this patch is based on Robert's B. Easter work from 2001 year.
> http://archives.postgresql.org/pgsql-patches/2001-01/msg00022.php

IIRC, that patch was rejected at the time because of performance issues
--- the optimizer could not turn it into an indexscan.  I think that
problem may have gone away by now, but did you check?

Also, you neglected to add the new keywords to the right keyword list
(so that they won't be any more reserved than necessary).

Also, a change like this is hardly just in the parser.  Please include
the needed documentation changes.  It's simple enough to probably not
need a regression test, but that's always something to think about when
completing a TODO, too.

            regards, tom lane

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: patch for between symmetric, asymmetric (from TODO)
Next
From: Tom Lane
Date:
Subject: Re: patch for between symmetric, asymmetric (from TODO)