Dave Cramer <[EMAIL PROTECTED]> writes: > davec=# explain analyze select * from url where fn_strrev(url) like > '%beta12.html';
Don't you need the % at the right end to have an indexable plan?
I suspect that both of your tries so far are actually semantically
wrong, and that what you intend is
select * from url where fn_strrev(url) like fn_strrev('%beta12.html');
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
