Re: does postgres has the same limitation as MySQL?

["Jonah H. Harris" <jonah.harris@xxxxxxxxx>]

On Mon, Jan 5, 2009 at 12:05 PM, Chris Browne <cbbrowne@xxxxxxx> wrote:

tekion <tekion@xxxxxxxxx> writes:
> I know that MySQL can only use one index at at time for query. Does
> Postgres has this same limitation? For example, the following query:

This is false for many cases since MySQL 5.0.

http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

-- 
Jonah H. Harris, Senior DBA
myYearbook.com