Re: [GENERAL] btree index on a char(8) field (fwd)

On Thu, 7 Oct 1999, Frank Mandarino wrote:

> Gene,
>
> Thanks for your response.
>
> I knew from the programming documentation that the opclass was optional.
> I'm pretty sure, although I will check again tonight, that I tried
> creating the index without specifying the opclass, but I found that the
> index was still not used in my example query.
>
> Do you know which opclass that Postgres should choose for char(8) types?
>
> Regards,
> ../fam
>

--
Frank A. Mandarino                fam@risca.com
Infrasoft Inc.
(905) 877-1752    Days: (416) 350-5261