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
==========================================================================
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 |