From: Mike Mascari <mascarm@mascari.com>
To: Constantin Teodorescu <teo@flex.ro>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: No default operator type for indexes for numeric fields???
Date: Tue, 11 Apr 2000 10:07:55 -0400
Message-ID: <38F331BB.638CA329@mascari.com> (raw)
References: <38F32A73.716E1243@flex.ro>
Constantin Teodorescu wrote:
>
> 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
According to the release history, this appears to be something
that has been added for 7.0:
Types
-----
...
Add btree index on NUMERIC(Jan)
...
Mike Mascari
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mascarm@mascari.com, teo@flex.ro
Subject: Re: No default operator type for indexes for numeric fields???
In-Reply-To: <38F331BB.638CA329@mascari.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox