Revision 596c6378
Von Moritz Bunkus vor fast 17 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 809 | 809 |
FROM acc_trans ac |
| 810 | 810 |
JOIN chart c ON (ac.chart_id = c.id) |
| 811 | 811 |
$dpt_join |
| 812 |
WHERE (ac.transdate < (select date_trunc('year', date ?)))
|
|
| 812 |
WHERE (ac.transdate < (select date_trunc('year', ?::date)))
|
|
| 813 | 813 |
$dpt_where |
| 814 | 814 |
$project |
| 815 | 815 |
GROUP BY c.accno, c.category, c.description |; |
Auch abrufbar als: Unified diff
Kompatibilitätsfix für PostgreSQL 8 und neuer.