Index: openacs-4/packages/logger/tcl/project-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/logger/tcl/project-procs-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/logger/tcl/project-procs-postgresql.xql 11 Dec 2003 21:40:07 -0000 1.4 +++ openacs-4/packages/logger/tcl/project-procs-postgresql.xql 5 Jan 2004 21:05:27 -0000 1.5 @@ -33,4 +33,14 @@ + + + select min(p.projection_id) + from logger_projections p + where p.project_id = :project_id + and p.variable_id = :variable_id + and current_timestamp between p.start_time and p.end_time + + +