Re: [GENERAL] btree index on a char(8) field (fwd) - Mailing list pgsql-general

From Frank Mandarino
Subject Re: [GENERAL] btree index on a char(8) field (fwd)
Date
Msg-id 99Oct7.203557edt.115201@sky.risca.com
Whole thread Raw
In response to Re: [GENERAL] btree index on a char(8) field (fwd)  (Frank Mandarino <fam@risca.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jim Cromie
Date:
Subject: Bug? inheriting primary key
Next
From: Frank Mandarino
Date:
Subject: Re: [GENERAL] btree index on a char(8) field (fwd)