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 or flat)
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

 

Responses

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-2014 The PostgreSQL Global Development Group