Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA7NnBs03341 for ; Tue, 7 Nov 2000 18:49:11 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eA7Nma522503; Tue, 7 Nov 2000 18:48:36 -0500 (EST) To: Forest Wilkinson cc: pgsql-sql@postgresql.org Subject: Re: how to index a numeric(12,2) column? In-reply-to: References: Comments: In-reply-to Forest Wilkinson message dated "Tue, 07 Nov 2000 14:57:59 -0800" Date: Tue, 07 Nov 2000 18:48:35 -0500 Message-ID: <22500.973640915@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/54 X-Sequence-Number: 85 Forest Wilkinson writes: > I'd like to create an index on a column whose type is NUMERIC(12,2). > There appears to be no default operator class for the numeric type. Uh, what version are you using? Works fine for me in 7.0.2. regards, tom lane