Received: from flex.flex.ro (IDENT:root@[193.230.255.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA36720
	for <pgsql-interfaces@postgresql.org>;
	Tue, 11 Apr 2000 09:37:09 -0400 (EDT) (envelope-from teo@flex.ro)
Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3])
	by flex.flex.ro (8.9.3/8.9.3) with ESMTP id QAA12630
	for <pgsql-interfaces@postgresql.org>; Tue, 11 Apr 2000 16:42:02 +0300
Message-ID: <38F32A73.716E1243@flex.ro>
Date: Tue, 11 Apr 2000 16:36:51 +0300
From: Constantin Teodorescu <teo@flex.ro>
X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.14 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: No default operator type for indexes for numeric fields???
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200004/65

I have the following table structure:

+----------+-----------------------------+-------+
|  Field   |              Type           | Length|
+----------+-----------------------------+-------+
| perioada | int2 not null               |     2 |
| gestiune | int2 not null               |     2 |
| produs   | int4 not null               |     4 |
| pret     | numeric not null            | 30.2  |
| initial  | numeric not null default 0  | 25.3  |
| intrari  | numeric not null default 0  | 25.3  |
| iesiri   | numeric not null default 0  | 25.3  |
+----------+-----------------------------+-------+ 

Trying to create an index like

create unique index stocuri_pkey on stocuri
(perioada,gestiune,produs,pret);

I got the following error:

ERROR:  Can't find a default operator class for type 1700.

How should I create an index using a numeric field?

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA