indexes and floats

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: [hackers](at)paprika(dot)michvhf(dot)com, hackers(at)postgreSQL(dot)org
Subject: indexes and floats
Date: 1998-08-03 00:26:43
Message-ID: XFMail.980802202643.vev@michvhf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Is this a bug that the index doesn't work on floats or is it a datatype
mismatch thing?

-----

template1=> create table foo (x float4, y float4);
CREATE
template1=> create index foox on foo(x);
CREATE
template1=> create index fooy on foo(y);
CREATE
template1=> insert into foo values(123.45,678.90);
INSERT 239376 1
template1=> insert into foo values(123.25,678.95);
INSERT 239377 1
template1=> explain select * from foo where x = 123.4;
NOTICE: QUERY PLAN:

Seq Scan on foo (cost=0.00 size=0 width=8)

EXPLAIN
template1=>

-----

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Nielsen 1998-08-03 01:08:49 is this allowed here-- I am developing an interface to postgresql
Previous Message David Hartwig 1998-08-03 00:15:48 Re: [HACKERS] 6.4 Aggregate Bug