From: miquel_ibanez <miquel_ibanez@sumimail.com>
To: pgsql-sql@postgresql.org
Subject: operator class
Date: Wed, 27 Feb 2008 23:40:45 +0100
Message-ID: <000e01c87991$cab4bb40$6402a8c0@miguelvell> (raw)
Hello
I have just started with postgreSQL.
I have a file with the following commands :
CREATE TYPE t_cod_t_activ AS (
cod_t_activ CHAR(10)
);
CREATE TABLE tip_activ (
id_tip_activ t_cod_t_activ,
des_t_activ t_des_t_activ
);
CREATE INDEX i_tip_activ ON tip_activ (id_tip_activ bpchar_pattern_ops);
When the CREATE INDEX is executed, this error shows:
ERROR: operator class "bpchar_pattern_ops" does not accept data type
t_cod_t_activ
Does it mean that I cannot create an index on a field wich is of a type
defined by the user?
I need that id_tip_activ be PRIMARY KEY.
Thanks and best regards
Miguel Ibáñez
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: miquel_ibanez@sumimail.com
Subject: Re: operator class
In-Reply-To: <000e01c87991$cab4bb40$6402a8c0@miguelvell>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox