PostgreSQL variables throwing syntax error

Question

I am trying to declare a variable in PostgreSQL. No matter what I do, it's always a syntax error.

declare x integer := 1;
x := 1;
declare x := 1;
@declare x := 1;

Yes, I know variables only work in queries written in plpgsql. I've read this answer everywhere, but no explanation whatsoever on how to switch to it. Can please someone explain it to me in very simple terms?

Mike Organek · Accepted Answer · 2020-09-17 22:38:16Z

1

What do you plan to do with x?

do language plpgsql
$$
declare x int := 1;
begin
  raise notice '%', x;
end
$$
;

NOTICE:  1
DO

answered Sep 17, 2020 at 22:38

Mike Organek

12.6k3 gold badges15 silver badges28 bronze badges

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

2 Comments

Tamás Polgár Over a year ago

Now I got it, I have to declare a function. Thank you, sir!

Mike Organek Over a year ago

@TamásPolgár This is not a function. It is a do block.

Collectives™ on Stack Overflow

PostgreSQL variables throwing syntax error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related