changed create_user to return users.id if successful

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@275 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 2 insertions, 2 deletions

diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql
index 5201e55e..c9771e4d 100755
--- a/sql/Pg-tables.sql
+++ b/sql/Pg-tables.sql
@@ -761,10 +761,10 @@ INSERT INTO users_conf(id,password) VALUES (currval('users_id_seq'),NULL);
 
 CREATE FUNCTION create_user(text) RETURNS int4 AS $$
    INSERT INTO users(username) VALUES ('$1');
-   SELECT 1;
+   SELECT currval('user_id_seq');
    $$ LANGUAGE 'SQL';
 
-COMMENT ON FUNCTION create_user(text) IS $$ Function to create user. Returns 1 if successful, else it is an error. $$;
+COMMENT ON FUNCTION create_user(text) IS $$ Function to create user. Returns users.id if successful, else it is an error. $$;
 
 CREATE FUNCTION update_user(int4,text) RETURNS int4 AS $$
    UPDATE users SET username = '$2' WHERE id = $1;