Can't create an index on NUMERIC(x,y)

From: secret <secret(at)kearneydev(dot)com>
To: PG-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Can't create an index on NUMERIC(x,y)
Date: 1999-11-18 16:08:59
Message-ID: 3834249B.4EBCAA4@kearneydev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


ftc=> create index z_test on z(a);
ERROR: Can't find a default operator class for type 1700.
ftc=> \d z
Table = z
+----------------------------------+----------------------------------+-------+

| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+

| a | numeric |
9.3 |
+----------------------------------+----------------------------------+-------+

As you can see above when I try to create an index on a NUMERIC it can't
find the default operator for type xxx, is there a way to fix this? It
hasn't worked since numerics were revised in (6.0?)...

Any advise would be very appreciated, please cc: secret(at)kearneydev(dot)com
not just the list :)

--David

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 1999-11-18 22:18:03 Re: [SQL] Can't create an index on NUMERIC(x,y)
Previous Message Mario Olimpio de Menezes 1999-11-18 09:49:33 please help me on pl/pgsql triggers (fwd)