diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Company.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index b7f5e640..b5dd76cc 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -220,11 +220,11 @@ BEGIN END; $$ LANGUAGE PLPGSQL; -CREATE OR REPLACE FUNCTION company_retrieve (in_id int) RETURNS company AS +CREATE OR REPLACE FUNCTION company_retrieve (in_entity_id int) RETURNS company AS $$ DECLARE t_company company; BEGIN - SELECT * INTO t_company FROM company WHERE id = in_id; + SELECT * INTO t_company FROM company WHERE entity_id = in_entity_id; RETURN t_company; END; $$ language plpgsql; |