Hi all,

I'm trying to create an index on a composite key using a DECIMAL type
but PostgreSQL raises the following error:


CREATE TABLE header (
        year                    decimal(4) NOT NULL,
        number                  INTEGER  NOT NULL,
        date                    DATE     NOT NULL,
        cod_client              CHAR(4)  NOT NULL,
        CONSTRAINT k_header PRIMARY KEY (year,number)
        );
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'k_header'
for tabl
e 'header'
ERROR:  Can't find a default operator class for type 1700.

-----------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1

Josï¿½


Tue, 10 Aug 1999 10:05:13 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
another DECIMAL problem 
> I'm trying to create an index on a composite key using a DECIMAL type
> but PostgreSQL raises the following error:
> ERROR:  Can't find a default operator class for type 1700.

afaik Postgres does not yet implement indices for NUMERIC or DECIMAL.
Don't know if anyone has plans to do so...

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Tue, 10 Aug 1999 13:17:36 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] another DECIMAL problem
> > I'm trying to create an index on a composite key using a DECIMAL type
> > but PostgreSQL raises the following error:
> > ERROR:  Can't find a default operator class for type 1700.
> 
> afaik Postgres does not yet implement indices for NUMERIC or DECIMAL.
> Don't know if anyone has plans to do so...
> 
>                    - Thomas

TODO list has:

	* Add index on NUMERIC/DECIMAL type

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 10 Aug 1999 12:56:13 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] another DECIMAL problem
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi all,
> 
> I'm trying to create an index on a composite key using a DECIMAL type
> but PostgreSQL raises the following error:
> 
> 
> CREATE TABLE header (
>         year                    decimal(4) NOT NULL,
>         number                  INTEGER  NOT NULL,
>         date                    DATE     NOT NULL,
>         cod_client              CHAR(4)  NOT NULL,
>         CONSTRAINT k_header PRIMARY KEY (year,number)
>         );
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'k_header'
> for tabl
> e 'header'
> ERROR:  Can't find a default operator class for type 1700.
> 

We have the TODO item:

	* Add index on NUMERIC/DECIMAL type

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 27 Sep 1999 14:05:29 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] another DECIMAL problem
Bruce Momjian wrote:

> > ERROR:  Can't find a default operator class for type 1700.
>
> We have the TODO item:
>
>    * Add index on NUMERIC/DECIMAL type
>

    Nbtree operator class for NUMERIC is committed.

    Item closed.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #



Wed, 29 Sep 1999 23:10:03 +0200 (MET DST)
wieck@debis.com (Jan Wieck)
Re: [HACKERS] another DECIMAL problem
> Bruce Momjian wrote:
> 
> > > ERROR:  Can't find a default operator class for type 1700.
> >
> > We have the TODO item:
> >
> >    * Add index on NUMERIC/DECIMAL type
> >
> 
>     Nbtree operator class for NUMERIC is committed.
> 
>     Item closed.
> 

TODO item marked as completed:

	* -Add index on NUMERIC/DECIMAL type

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 29 Sep 1999 17:40:55 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] another DECIMAL problem