BUG #16181: Error Creating Stored Procedures
PG Bug reporting form <[email protected]> Wed, 01 Jan 2020 23:42:44 +0000
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
The following bug has been logged on the website: Bug reference: 16181 Logged by: Shahzad Ahmad Email address: [email protected] PostgreSQL version: 12.1 Operating system: Ubuntu 18.04.3 LTS Description: I tried both pgAdmin GUI and psql using a script file. In both instances i got the same error. CREATE OR REPLACE PROCEDURE admin.my_test(IN role_id integer DEFAULT 0) LANGUAGE 'plpgsql' AS $BODY$ IF my_test.user_id = 0 THEN Select * from admin.roles order by role_name; ELSE Select * from admin.roles WHERE role_id = my_test.user_id order by role_name; END IF; $BODY$; ERROR: syntax error at or near "IF" LINE 5: IF my_test.user_id = 0 THEN ^ SQL state: 42601 Character: 103