Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA06937 for ; Mon, 24 May 1999 20:39:26 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id UAA01780; Mon, 24 May 1999 20:38:06 -0400 (EDT) To: Mirek Budzanowski cc: pgsql-sql@hub.org Subject: Re: [SQL] index on int8 in PG 6.4.2 In-reply-to: Your message of Tue, 25 May 1999 01:46:29 +0200 (MET DST) <199905242346.BAA13369@pogwizd.ii.uni.wroc.pl> Date: Mon, 24 May 1999 20:38:05 -0400 Message-ID: <1778.927592685@sss.pgh.pa.us> From: Tom Lane Mirek Budzanowski writes: > Anyone have any idea how to define a index ont int8 field? Postgres 6.4 doesn't have support for indexes on int8. In theory you could add it for yourself (there is some documentation about index operators in the Developer's Guide) but it's not a simple job. You would probably be better off to wait for 6.5, which does have int8 index support... regards, tom lane