Re: [GENERAL] optimizing "between" queries

2001-01-22 Thread Tom Lane
Kyle <[EMAIL PROTECTED]> writes: > I have a table where I need to select elements that are between > certain values. The typical query would be like: > select foo from bar where >element1 between ? and ? and -- using some val_1a and val_1b >element2 between ? and ? and -- usi

[GENERAL] optimizing "between" queries

2001-01-22 Thread Kyle
I have a table where I need to select elements that are between certain values. The typical query would be like: select foo from bar where element1 between ? and ? and -- using some val_1a and val_1b element2 between ? and ? and -- using some val_2a and val_2b ...