Kompatibilitätsfix für PostgreSQL 8 und neuer.

diff --git a/SL/RP.pm b/SL/RP.pm
index 76c44e12e7e60cf5f6db961501d9b5b28de2e3c6..33912bae5f3c32d238e2382daa7eb78d3aec1c6a 100644 (file)
--- a/SL/RP.pm
+++ b/SL/RP.pm
@@ -809,7 +809,7 @@ sub trial_balance {
         FROM acc_trans ac
         JOIN chart c ON (ac.chart_id = c.id)
         $dpt_join
-        WHERE (ac.transdate < (select date_trunc('year', date ?)))
+        WHERE (ac.transdate < (select date_trunc('year', ?::date)))
           $dpt_where
           $project
         GROUP BY c.accno, c.category, c.description |;