Bruno Wolff III wrote: > 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.
But it uses two different tables. You can't mix tables in an index, can you? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
