On Tue, 27 Jan 2004, Dave Cramer wrote:
> same answer
>
> davec=# show enable_seqscan;
> enable_seqscan
> ----------------
> off
> (1 row)
>
> davec=# explain analyze select * from url where fn_strrev(url) like
> '%beta12.html';
That's still an unanchored like clause, besides I think that would get
urls that begin with lmth.21ateb.
I think the condition you want would be:
fn_strrev(url) like 'lmth.21ateb%'
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
