Postgres Pro
Downloads
Home   >   mailing lists

Thread: BETWEEN SYMMERIC

BETWEEN SYMMERIC

From
"Christopher Kings-Lynne"
Date:
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

Re: BETWEEN SYMMERIC

From
Bruce Momjian
Date:
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

Re: BETWEEN SYMMERIC

From
Tom Lane
Date:
"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

Re: BETWEEN SYMMERIC

From
Rod Taylor
Date:
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.