Received: from nexus.kearneydev.com (IDENT:root@nexus.kearneydev.com [208.136.214.2]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA91566 for ; Thu, 18 Nov 1999 11:09:24 -0500 (EST) (envelope-from secret@kearneydev.com) Received: from kearneydev.com (atu.kearneydev.com [208.136.214.93]) by nexus.kearneydev.com (8.8.5/8.8.5) with ESMTP id LAA24088 for ; Thu, 18 Nov 1999 11:08:58 -0500 Message-ID: <3834249B.4EBCAA4@kearneydev.com> Date: Thu, 18 Nov 1999 11:08:59 -0500 From: secret Organization: Kearney Development Co., Inc. X-Mailer: Mozilla 4.51 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: PG-SQL Subject: Can't create an index on NUMERIC(x,y) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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@kearneydev.com not just the list :) --David