indexes and floats
От | Vince Vielhaber |
---|---|
Тема | indexes and floats |
Дата | |
Msg-id | XFMail.980802202643.vev@michvhf.com обсуждение исходный текст |
Список | 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@michvhf.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 ==========================================================================
В списке pgsql-hackers по дате отправления: