How do I assign a variable with the first selected value in Postgres syntax?

Question

I try this:

myvar := select "name" from "mytable" where "id" = 15;

But it causes an error. How can I assign the variable correctly?

Vao Tsun · Accepted Answer · 2016-12-23 11:01:36Z

1

select "name" into myvar from "mytable" where "id" = 15;

or

myvar := (select "name" from "mytable" where "id" = 15);

answered Dec 23, 2016 at 11:01

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Comments

Gehtnet · Accepted Answer · 2016-12-23 11:28:39Z

1

It will work when you are using the INTO Keyword like

select "name" into myvar from "mytable" where "id" = 15;

But its possible that this returns more than one row. (Throws an Error in Oracle-SQL, cant speak for Postgres)

I think somithing like

select "name" into myvar from "mytable" where "id" = 15 limit 1;

would be better to fit your question title.

answered Dec 23, 2016 at 11:28

Gehtnet

48711 silver badges27 bronze badges