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

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: Frank Mandarino <fam(at)risca(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] btree index on a char(8) field (fwd)
Date: 1999-10-06 13:47:36
Message-ID: l03130301b421030e5355@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jelle Ruttenberg 1999-10-06 14:28:23 Q: ODBC- and PostgreSQL-datatypes difference?
Previous Message Bruce Momjian 1999-10-06 13:38:01 Re: [GENERAL] Foreign Key