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@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. ____________
