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

[..hidden..]

Revision: 3507
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3507&view=rev
Author:   einhverfr
Date:     2011-07-14 05:01:37 +0000 (Thu, 14 Jul 2011)

Log Message:
-----------
Date.sql docstrings added and updated

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

Modified: trunk/sql/modules/Date.sql
===================================================================
--- trunk/sql/modules/Date.sql	2011-07-13 21:27:56 UTC (rev 3506)
+++ trunk/sql/modules/Date.sql	2011-07-14 05:01:37 UTC (rev 3507)
@@ -1,3 +1,9 @@
+
+-- Copyright (C) 2011 LedgerSMB Core Team.  Licensed under the GNU General 
+-- Public License v 2 or at your option any later version.
+
+-- Docstrings already added to this file.
+
 CREATE OR REPLACE FUNCTION date_get_all_years() returns setof INT AS
 $$
 DECLARE next_record int;
@@ -22,7 +28,9 @@
 END;
 $$ language plpgsql;                                                                  
 COMMENT ON FUNCTION date_get_all_years() IS
-$$ This function return each year inside transdate in transactions. $$;
+$$ This function return each year inside transdate in transactions. 
+Currently it uses a sparse index scan because the number of rows returned is 
+very small and the table can be very large.$$;
 
 CREATE OR REPLACE FUNCTION is_leapyear(in_date date) returns bool as
 $$


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