On Wed, Apr 07, 2004 at 06:01:03 -0700, Michael Groth <[EMAIL PROTECTED]> wrote: > hi, > > is it possible to use an index on the expression '(table_1.field & > table_2.field)::int > 0' ? > > here's the whole query: > > SELECT > COUNT(*) > FROM > users AS users > JOIN > search_profile AS search_profile ON > (search_profile.bin_matching_field_0 & > users.bin_matching_field_0)::int > 0 > WHERE > users.id = 190
In 7.4 you can create indexes on expressions. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
