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

SF.net SVN: ledger-smb: [2004] trunk/sql/modules/Account.sql



Revision: 2004
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2004&view=rev
Author:   einhverfr
Date:     2007-12-26 13:11:59 -0800 (Wed, 26 Dec 2007)

Log Message:
-----------
Fixing broken Account.sql

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

Modified: trunk/sql/modules/Account.sql
===================================================================
--- trunk/sql/modules/Account.sql	2007-12-26 17:00:47 UTC (rev 2003)
+++ trunk/sql/modules/Account.sql	2007-12-26 21:11:59 UTC (rev 2004)
@@ -1,6 +1,6 @@
 -- VERSION 1.3.0
 
-CREATE OR REPLACE FUNCTION account_get (in_id) RETURNS chart AS
+CREATE OR REPLACE FUNCTION account_get (in_id int) RETURNS chart AS
 $$
 DECLARE
 	account chart%ROWTYPE;
@@ -10,7 +10,7 @@
 END;
 $$ LANGAUGE plpgsql;
 
-CREATE OR REPLACE FUNCTION account_is_orphaned (in_id) RETURNS bool AS
+CREATE OR REPLACE FUNCTION account_is_orphaned (in_id int) RETURNS bool AS
 $$
 BEGIN
 	SELECT trans_id FROM acc_trans WHERE chart_id = in_id LIMIT 1;


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