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

1999-10-08 Thread Gene Selkov, Jr.
Frank Mandarino wrote: > 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 use

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

1999-10-06 Thread Herouth Maoz
At 15:30 +0200 on 06/10/1999, Frank Mandarino wrote: > main=> create index ven_code_idx on vendor using btree (ven_code char_ops); > CREATE I didn't have time to check this, but the problem may be caused by the incorrect ops you are using. For char(N) it should be bpchar_ops, not char_ops. Her

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

1999-10-06 Thread Frank Mandarino
Hi, I sent out the forwarded message below last Sunday, and have received no responses. Now I realize that this list operates on a volunteer basis and that everyone is busy, so I am in no way demanding or expecting an answer, but I would really like to know if there is something wrong with the m