diff options
| -rw-r--r-- | sql/modules/Account.sql | 4 |
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; |