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 MIN

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 connection

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? You are