index
:
ikiwiki-upstream
layoutgala
master
Unnamed repository; edit this file to name it for gitweb.
Jonas Smedegaard
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
doc
/
plugins
diff options
context:
1
2
3
4
CREATE OR REPLACE FUNCTION
date_get_all_years
()
returns setof
INT
AS
$$
DECLARE
date_out record
;
BEGIN
FOR
date_out
IN
SELECT EXTRACT
(
'YEAR'
from
transdate
)
AS year
FROM
acc_trans
GROUP BY EXTRACT
(
'YEAR'
from
transdate
)
ORDER BY year
LOOP
return next
date_out.
year
;
