Concatenate string in statement that assigns a variable in PostgreSQL

Question

I am trying to convert SQL Server procedure to PostgreSQL.

In the SQL Server procedure There are statements like below

SET @val = '(' + @someval + ')'

So in postgresql I wrote as below

SET val = '(' || someval || ')';

But the above statement giving error at ||

Any body can please tell me where am I making mistake

Can you share the whole procedure with us? It might not be the concatenation itself, but rather the where that statement is being interpreted. — Will
– Will, Commented Oct 17, 2013 at 5:57
Please read the manual: postgresql.org/docs/current/static/… — user330315
– user330315, Commented Oct 17, 2013 at 6:12

roman · Accepted Answer · 2013-10-17 06:19:13Z

14

AFAIK, SET statement in PostgreSQL used for changing configutation parameters, for variable assignment just use :=:

val := '(' || someval || ')';

answered Oct 17, 2013 at 6:06

roman

118k30 gold badges205 silver badges209 bronze badges

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

1 Answer 1