On Tue, 31 May 2011 15:47:45 +0200, Michael Wood <esiotrot(at)gmail(dot)com> wrote:
> If you run:
> explain analyze select name from test2 where major = const and minor = const;
> explain analyze select name from test2 where minor = const and major = const;
> you will see that the query planner is clever enough to see that they
> are the same.
I was almost sure about that:)
And miles to go before I sleep.
-- Robert Frost
In response to
pgsql-novice by date
|Next:||From: Mark Wimer||Date: 2011-05-31 16:54:55|
|Subject: Re: Create GEOM Column|
|Previous:||From: Michael Wood||Date: 2011-05-31 13:47:45|
|Subject: Re: indexes multicolumn|