Received: from summersault.com (qmailr@nollie.summersault.com [199.120.185.41]) by hub.org (8.9.3/8.9.3) with SMTP id TAA97697 for ; Sun, 23 Jan 2000 19:35:16 -0500 (EST) (envelope-from mark@summersault.com) Received: (qmail 92258 invoked from network); 24 Jan 2000 00:35:15 -0000 Received: from mark.summersault.com (HELO summersault.com) (199.120.185.113) by nollie.summersault.com with SMTP; 24 Jan 2000 00:35:15 -0000 Message-ID: <388B9E44.F3378DDE@summersault.com> Date: Sun, 23 Jan 2000 19:36:07 -0500 From: Mark Stosberg Reply-To: mark@summersault.com Organization: Summersault X-Mailer: Mozilla 4.7 (Macintosh; I; PPC) X-Accept-Language: en,pdf MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: can I index a field of type "point"? References: <3882ADE3.BC7B6824@summersault.com> <8766wlj00q.fsf@ghidra.vail> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! Is there a way to index a point field? The obvious method didn't work for me: mark=> create index lon_lat_idx on zip (lon_lat); ERROR: Can't find a default operator class for type 600 I'm using Postgres v 6.5.3 Thanks, -mark <<-------------------------------------------------------------->> personal website < Summersault Website Design http://mark.stosberg.com/ > http://www.summersault.com/