On Sep 13, 2005, at 3:07 PM, Craig wrote: Hi I have a query that is grouping by 3 fields and returning a sum of another field. I would also like a further field to be returned that shows a ranking for the records based on the sum field. This should really only be a numbering of the rows returned
On Sep 16, 2005, at 9:18 AM, Bill Moseley wrote:
First question is why the planner is not using an index scan when I
use "now()" or CURRENT_TIMESTAMP?
It also used to be the case (pre-8.0; I couldn't find in the release
notes whether this was an 8.0 or 8.1 fix) that now() and
CURRENT_TIME
