Re: [GENERAL] btree index and max()

2000-06-01 Thread Elliot Finley
On Thu, 1 Jun 2000 19:10:48 -0300, [EMAIL PROTECTED] wrote: >> [EMAIL PROTECTED] writes: >> > I understand that the query planner cannot be so clever >> > to grasp that this particular function (max or min) >> > might be evaluated by just travelling the BTREE index. >> > Am I correct? >> >

Re: [GENERAL] btree index and max()

2000-06-01 Thread leonbloy
> [EMAIL PROTECTED] writes: > > I understand that the query planner cannot be so clever > > to grasp that this particular function (max or min) > > might be evaluated by just travelling the BTREE index. > > Am I correct? > > You are correct --- the system has no idea that there is any > c

Re: [GENERAL] btree index and max()

2000-06-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > I understand that the query planner cannot be so clever > to grasp that this particular function (max or min) > might be evaluated by just travelling the BTREE index. > Am I correct? You are correct --- the system has no idea that there is any connection between the MI