Christopher Kings-Lynne wrote:
select * from my_table where row_num >= 50000 and row_num < 100000 and myfunc(foo, bar);You just create an index on myfunc(foo, bar)
Thanks, but myfunc() takes parameters (shown here as "foo, bar"), one of which
is not a column, it's external and changes with every query. A function index won't work.
Craig
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
