facing syntax error at or near if postgres

Question

I am new to POSTGRES and currently exploring how to create and execute stored procedures. I was trying a simple example with conditional constructs and got stuck with an error :(

create procedure learnpostgre(x integer, y integer)
language plpgsql
as $$
if x > y
then
raise 'X is greater'
end if
$$;

The error I am getting is 'syntax error at or near if'. I saw similar issues on SO and tried wrapping my code block under do block but faced the same error message for 'Do'. I am running my code in pgadmin4 and postgres version is 14.X

As documented in the manual you need a begin ... end block in PL/pgSQL — user330315
– user330315, Commented Feb 4, 2022 at 15:12

Zakaria · Accepted Answer · 2022-02-04 15:17:12Z

1

You're missing begin and end and a few semicolons. This should work:

create procedure learnpostgre(x integer, y integer)
language plpgsql
as $$
begin
if x > y
then
raise 'X is greater';
end if;
end
$$

answered Feb 4, 2022 at 15:17

Zakaria

4,7762 gold badges9 silver badges37 bronze badges

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

1 Comment

subhrendu Over a year ago

it worked. Thanks. I guess I am still confusing it with sql syntax.

Collectives™ on Stack Overflow

facing syntax error at or near if postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related