Skip site navigation (1) Skip section navigation (2)

operator class

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-sql


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


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



pgsql-sql by date

Next:From: Dawid KuroczkoDate: 2008-02-28 00:01:57
Subject: Subselects returning array and ANY...
Previous:From: Professor Flávio BritoDate: 2008-02-27 20:42:23
Subject: Re: Function returns error (view)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group