1/ I've posted a bug report and a resolve to it Jeff. Can you tell me if this is right? I don't know how to use cvs and specifficaly diff to create a patch though:
https://openacs.org/bugtracker/openacs/bug?filter%2estatus=resolved&bug%5fnumber=1958
2/ in packages/robot-detection/tcl/robot-detection-procs-postgresql.xql
I would need to change:
===============================================
select trunc(current_timestamp - max(coalesce(modified_date, in\
sertion_date))) from robots
===============================================
to use
===============================================
"date_part('days',current_timestamp - max(coalesce(modified_date, insertion_date)))".
===============================================
Is this the correct way to use date_part?
thanks
