Re: Between Node - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Between Node
Date
Msg-id 200207181704.g6IH4GG19490@candle.pha.pa.us
Whole thread Raw
In response to Between Node  (Rod Taylor <rbt@zort.ca>)
Responses Re: Between Node
List pgsql-patches
Rod, I have backed out this patch because initdb was failing.  Please
retest and resubmit.  You may want to get the optimizer recoginizing
BETWEEN in the same patch so we don't go backwards in terms of
optimization.

---------------------------------------------------------------------------

Rod Taylor wrote:
> Finished the Between patch Christopher started.
>
> Implements between (symmetric / asymmetric) as a node.
>
> Executes the left or right expression once, makes a Const out of the
> resulting Datum and executes the >=, <= portions out of the Const sets.
>
> Of course, the parser does a fair amount of preparatory work for this to
> happen.

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CLUSTER patch
Next
From: Rod Taylor
Date:
Subject: Re: Between Node