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
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 |