Re: Operator Classes and ANALYZE

On Mon, 2006-11-06 at 14:47 -0700, Rusty Conover wrote:

> I just
> want the ANALYZE call to use the index's opclass definitions of = and
> < if the index is created with a custom operator class that is not
> the default for the data type.

Which is exactly what the manual specifically says it doesn't do,
therefore you'll need the analyze_function. That capability was put
there deliberately to help you out, in this situation.

> I don't think I need to write my own analyze function

That is the solution, not a workaround.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com