Re: [PERFORM] Use of multipart index with "IN"

2003-10-27 Thread Tom Lane
Rob Messer <[EMAIL PROTECTED]> writes: > The problem comes in when we are selecting multiple field_name values > in one query. The normal SQL syntax we have been using is like this: > select field_name, option_tag from ds_rec_fld where recid = 3001 and > field_name in ('Q3A1', 'Q3A9'); You'd hav

[PERFORM] Use of multipart index with "IN"

2003-10-24 Thread Rob Messer
I have a reporting system that does regular queries on a table with a multipart index. I am running version 7.3.4. Here is the table definition: Table "public.ds_rec_fld" Column | Type | Modifiers ---+-+--- ds