Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA28183 for ; Tue, 14 Sep 1999 13:17:02 -0400 (EDT) (envelope-from echiner@tissat.es) Received: from tissat.es ([195.77.30.15]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA6320 for ; Tue, 14 Sep 1999 19:16:21 +0200 Message-ID: <37DE826E.A622B22@tissat.es> Date: Tue, 14 Sep 1999 19:14:22 +0200 From: "Esteban Chiner Sanz" X-Mailer: Mozilla 4.5 [es] (WinNT; U) X-Accept-Language: es MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Primary key on NUMERIC type Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.es TISSAT Av. Aragon, 30, 5ª planta Phone: 96 393 9950 Valencia (SPAIN)