Обсуждение: BETWEEN SYMMERIC

Whatver happened to Rod's work on the BETWEEN command?  I remember he got to
the stage of realising a lot of execetor changes had to be made...?

Chris

Christopher Kings-Lynne wrote:
> Whatver happened to Rod's work on the BETWEEN command?  I remember he got to
> the stage of realising a lot of execetor changes had to be made...?

The problem was that the optimizer wouldn't recognize it as an
optimizable/indexable case so it would be worse than what we have now,
and I don't think we wanted or could continue.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Whatver happened to Rod's work on the BETWEEN command?

It got applied, some people reported failures, it was hastily backed
out, and no one seems to have followed up on it.

At this point I'd say it's not happening for 7.3 ...
        regards, tom lane

On Mon, 2002-09-02 at 02:36, Christopher Kings-Lynne wrote:
> Whatver happened to Rod's work on the BETWEEN command?  I remember he got to
> the stage of realising a lot of execetor changes had to be made...?

I've not had time to implement the optimizer portion.