[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[3449] trunk/sql/modules/Date.sql



Revision: 3449
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3449&view=rev
Author:   einhverfr
Date:     2011-07-06 01:23:53 +0000 (Wed, 06 Jul 2011)

Log Message:
-----------
Removing deprecated all_years function

Modified Paths:
--------------
    trunk/sql/modules/Date.sql

Modified: trunk/sql/modules/Date.sql
===================================================================
--- trunk/sql/modules/Date.sql	2011-07-05 15:10:18 UTC (rev 3448)
+++ trunk/sql/modules/Date.sql	2011-07-06 01:23:53 UTC (rev 3449)
@@ -138,11 +138,3 @@
 COMMENT ON FUNCTION periods_get() IS
 $$ Returns dates for year to date, and last year.$$;
 
-CREATE OR REPLACE FUNCTION all_years() returns setof int AS
-$$
-SELECT DISTINCT EXTRACT ('YEAR' FROM transdate)::int
-FROM acc_trans;
-$$ language sql;
-
-COMMENT ON FUNCTION all_years() IS
-$$ Returns all years currently found in the database.$$;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.