summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-12-26 21:11:59 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-12-26 21:11:59 +0000
commit367eb54a83b89f7b5c1fa344bea810dd0e50b90b (patch)
treed762de9e235c998b5f04484cb1bdf5f284d632a1 /sql
parentbfca312b29b73f9745c7477e63db3bd928bc3cc6 (diff)
Fixing broken Account.sql
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2004 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Account.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/modules/Account.sql b/sql/modules/Account.sql
index 283efff7..33c51ab1 100644
--- a/sql/modules/Account.sql
+++ b/sql/modules/Account.sql
@@ -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 @@ BEGIN
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;