Re: index on a box

Around 15:14 on Jun 21, 2001, Dustin Sallings said:

# select * from tmp where box(point(-121,37),point(-121,37)) @ b;
#
# Index Scan using tmp_bybox on tmp  (cost=0.00..238.59 rows=61 width=92)

    Ugh, any idea here?

create function box(point) returns box as
    'select box($1, $1)'
    language 'sql';

misc=# explain select * from tmp where box(point(-121, 37)) @ b;
NOTICE:  QUERY PLAN:

Seq Scan on tmp  (cost=0.00..2653.01 rows=61 width=92)

misc=# explain select * from tmp
misc-#    where box(point(-121,37),point(-121,37)) @ b;
NOTICE:  QUERY PLAN:

Index Scan using tmp_bybox on tmp  (cost=0.00..238.59 rows=61 width=92)

misc=# select box(point(-121, 37));
         box
---------------------
 (-121,37),(-121,37)

misc=# select box(point(-121,37),point(-121,37));
         box
---------------------
 (-121,37),(-121,37)

misc=# select 1 where box(point(-121,37),point(-121,37))=box(point(-121,
37));
 ?column?
----------
        1


--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________