No default operator type for indexes for numeric fields???

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: No default operator type for indexes for numeric fields???
Date: 2000-04-11 13:36:51
Message-ID: 38F32A73.716E1243@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Mike Mascari 2000-04-11 14:07:55 Re: No default operator type for indexes for numeric fields???
Previous Message Andrew C.R. Martin 2000-04-11 11:42:01 Bugs: Programming Language Functions