Re: Operator Classes and ANALYZE - Mailing list pgsql-bugs

From Simon Riggs
Subject Re: Operator Classes and ANALYZE
Date
Msg-id 1162851654.30200.195.camel@silverbirch.site
Whole thread Raw
In response to Re: Operator Classes and ANALYZE  (Rusty Conover <rconover@infogears.com>)
Responses Re: Operator Classes and ANALYZE
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Rusty Conover
Date:
Subject: Re: Operator Classes and ANALYZE
Next
From: Rusty Conover
Date:
Subject: Re: Operator Classes and ANALYZE