How to assign value of Postgres declared variable with result of SQL query

Question

I am writing a postgres function where I have declared a variable called fruit.

 $$
    DECLARE
      IN_fruit varchar;
      sql;
    BEGIN
        IN_fruit := EXECUTE 'SELECT fruit FROM fruits WHERE id = 1'

How can I get this work in a way that the result returned from this query is stored in the variable IN_fruit, which I can use for later use in my main SQL query.

Arlind Hajredinaj · Accepted Answer · 2015-03-30 22:35:35Z

1

Use the code below

SELECT INTO IN_fruit  fruit FROM fruits WHERE id = 1

Reference here http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-SELECT-INTO

answered Mar 30, 2015 at 22:35

Arlind Hajredinaj

8,5193 gold badges33 silver badges49 bronze badges

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

2 Comments

user3422637 Over a year ago

Thanks. It worked. This can also be written as: SELECT fruit INTO IN_fruit FROM fruits WHERE id = 1;

Arlind Hajredinaj Over a year ago

Yup. Your way is more logical because fruit "will be saved" into IN_fruit :).

Collectives™ on Stack Overflow

How to assign value of Postgres declared variable with result of SQL query

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