indexes multicolumn

Hi list,

as the doc says:

SELECT name FROM test2 WHERE major = constant AND minor = constant;

then it might be appropriate to define an index on the columns major and minor
together, e.g.:

CREATE INDEX test2_mm_idx ON test2 (major, minor);

I may ask a dumb question, but does the query planner also use such an
index with the inversed query, e.g.:

SELECT name FROM test2 WHERE minor = constant AND major = constant;

or am I obliged to define an inversed index?

JY
--
Everybody is going somewhere!!  It's probably a garage sale or a
disaster Movie!!