Primary key on NUMERIC type - Mailing list pgsql-sql

From Esteban Chiner Sanz
Subject Primary key on NUMERIC type
Date
Msg-id 37DE826E.A622B22@tissat.es
Whole thread Raw
List pgsql-sql
Isn't it possible to put a PRIMARY KEY on a NUMERIC type?
Here is what I do:
   CREATE TABLE MNT_TEXTOS(       TEX_CODIGO              NUMERIC(5) NOT NULL,       CONSTRAINT C_TEX PRIMARY KEY
(TEX_CODIGO));

And I get this error message:
   ERROR:  Can't find a default operator class for type 1700.

What could be the problem?
Thanks in advance,
           Esteban Chiner

------------------------------------------------------------Esteban Chiner Sanz        mailto (work):
echiner@tissat.esTISSATAv.Aragon, 30, 5ª planta  Phone: 96 393 9950Valencia (SPAIN)
 




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Array Madness
Next
From: "Stéphane FILLON"
Date:
Subject: Permission problem with COPY FROM