Why am I getting an error declaring / assigning variables in Postgres? [duplicate]

Question

I want to declare and assign variables on a Postgres 12.10 instance.

According to the Postgres documentation I should be able to declare and assign variables as follows

DECLARE
  x integer := 1;
  y integer := x + 1;

but I get the error

ERROR:  syntax error at or near "integer"
LINE 2:   x integer := 1;
            ^
SQL state: 42601
Character: 13

Can anyone see what I'm doing wrong?

Then that's no surprise. That segment of code alone doesn't make any sense and is not syntactically correct. — Laurenz Albe
– Laurenz Albe, Commented Dec 7, 2022 at 11:53
That is just a sample from a part of a function. Try using that in a full function code. — Cetin Basoz
– Cetin Basoz, Commented Dec 7, 2022 at 11:55

Cetin Basoz · Accepted Answer · 2022-12-07 11:57:21Z

1

That code from documentation was only a sample showing you that you could use the value of a former declared value in a latter variable assignment and not meant to be run alone. You should use that in a function. ie: Check this DBFiddle demo

answered Dec 7, 2022 at 11:57

Cetin Basoz

24k3 gold badges34 silver badges48 bronze badges

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

Comments

Raya · Accepted Answer · 2022-12-07 11:53:55Z

1

Try this syntax.

DO
$$
DECLARE
  x integer := 1;
  y integer := x + 1;
$$

edited Dec 7, 2022 at 11:53

answered Dec 7, 2022 at 11:50

Raya

111 silver badge6 bronze badges

5 Comments

Vinyl Warmth Over a year ago

I'm getting the same error

Raya Over a year ago

Updated my answer, try that.

user330315 Over a year ago

Please do not post code as images. See here for more details why: meta.stackoverflow.com/questions/285551

Raya Over a year ago

I didn't. I showed that it didn't throw his error. The code is above it.

Jim Jones Over a year ago

@Raya still, an image consumes much more storage than text :) Welcome to SO.

Collectives™ on Stack Overflow

Why am I getting an error declaring / assigning variables in Postgres? [duplicate]

2 Answers 2

Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Linked

Related