From: | "miquel_ibanez" <miquel_ibanez(at)sumimail(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | operator class |
Date: | 2008-02-27 22:40:45 |
Message-ID: | 000e01c87991$cab4bb40$6402a8c0@miguelvell |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dawid Kuroczko | 2008-02-28 00:01:57 | Subselects returning array and ANY... |
Previous Message | Professor Flávio Brito | 2008-02-27 20:42:23 | Re: Function returns error (view) |