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