Re: index on a box

Around 18:26 on Jun 21, 2001, Tom Lane said:

# You'd better declare the function as 'iscachable'. As is, the planner
# doesn't trust it to return a constant.

Got it! Tried a few variations on the create until I got this:

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

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

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

Thanks! :)

(oh, and would it be reasonable to list at least some of the
possible attributes in psql?)

--
SPY My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)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. ____________