[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [2004] trunk/sql/modules/Account.sql
- Subject: SF.net SVN: ledger-smb: [2004] trunk/sql/modules/Account.sql
- From: ..hidden..
- Date: Wed, 26 Dec 2007 13:12:00 -0800
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.