Incorrect syntax near 'PROCEDURE' postgresql

Question

My database is hosted in Amazon and I am using pgAdmin 4 to connect to it. I copy-pasted snippet from https://www.postgresql.org/docs/11/sql-createprocedure.html

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
   INSERT INTO tbl VALUES (a);
   INSERT INTO tbl VALUES (b);
$$;

The issue is that I get 'incorrect syntax near 'PROCEDURE' ' error

What is done wrong? Not sure how I check version of postgresql itself

user330315 · Accepted Answer · 2019-08-29 08:49:49Z

4

With Postgres 10, you need to use a function:

CREATE function insert_data(a integer, b integer)
  returns void
LANGUAGE SQL
AS $$
   INSERT INTO tbl VALUES (a), (b);
$$;

answered Aug 29, 2019 at 8:49

user330315

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

According to PostgreSQL documentation, syntax is supported in versions 11 and 12.

PostgreSQL: Documentation: 11: CREATE PROCEDURE

Documentation → PostgreSQL 11

Supported Versions: Current (11)

Development Versions: 12 / devel

Check PostgreSQL version on your server, run this query from PgAdmin:

SELECT version();

CommunityBot

11 silver badge

answered Aug 29, 2019 at 8:44

Yasen

4,5841 gold badge21 silver badges28 bronze badges

thanks, it is "PostgreSQL 10.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit" there is no way I create procedure for it?

@pwrigshihanomoronimo: use a function then