Re: Rtree on custom data types; type conversion stops index use. - Mailing list pgsql-hackers

Dave Blasby <dblasby@refractions.net> writes:
> gives the correct results.  Postgres automatically uses the
> agg_points3d() function to convert the BOX3D into an AGG_POINTS3D.  
> Unfortunately, it doesn't use the index scan anymore; it does a sequence
> scan.

First question: what Postgres version?

Next question (if PG >= 7.0): did you mark your type conversion routine
as cachable?
        regards, tom lane