Missing DATE selectivity

Simon Riggs wrote:

The TODO list has an item "add missing date selectivity", which is a
hang-over from 1999 or before.

Is this still an issue? Can somebody describe exactly what it is?

I can't find the exact discussion of what the problem was/is, so its
better to ask directly...

Good question. I see DATEOID in selfuncs.c, so my guess is that at one
time we didn't have it, but now we do, and I never realized it. I have
removed the mention and updated the entry to:

* Add missing rtree optimizer selectivity

-- 
  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, Pennsylvania 19073

On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:

Simon Riggs wrote:

The TODO list has an item "add missing date selectivity", which is a
hang-over from 1999 or before.

Is this still an issue? Can somebody describe exactly what it is?

I can't find the exact discussion of what the problem was/is, so its
better to ask directly...

Good question. I see DATEOID in selfuncs.c, so my guess is that at one
time we didn't have it, but now we do, and I never realized it. I have
removed the mention and updated the entry to:

* Add missing rtree optimizer selectivity

I thought rtree was no longer supported either...

Best Regards, Simon Riggs

Simon Riggs <simon@2ndquadrant.com> writes:

On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:

* Add missing rtree optimizer selectivity

I thought rtree was no longer supported either...

We still have rtree-like opclasses. I agree the TODO item is worded
in a way that makes it look obsolete though. How about

* Improve selectivity functions for geometric operators

regards, tom lane

Tom Lane wrote:

Simon Riggs <simon@2ndquadrant.com> writes:

On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:

* Add missing rtree optimizer selectivity

I thought rtree was no longer supported either...

We still have rtree-like opclasses. I agree the TODO item is worded
in a way that makes it look obsolete though. How about

* Improve selectivity functions for geometric operators

Thanks, updated.

-- 
  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, Pennsylvania 19073