On 12/15/05, Christopher Kings-Lynne <[EMAIL PROTECTED]> 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) > > Chris >
only if myfunc(foo, bar) is immutable... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq