Skip site navigation (1) Skip section navigation (2)

Re: Between Node

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Between Node
Date: 2002-07-18 17:04:16
Message-ID: 200207181704.g6IH4GG19490@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-patches by date

Next:From: Rod TaylorDate: 2002-07-18 17:39:16
Subject: Re: Between Node
Previous:From: Bruce MomjianDate: 2002-07-18 17:02:01
Subject: Re: Between Node

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group