Postgres select into multiple values?

Question

PostgreSQL

Is it possible to write multiple variables in a query in plpgsql?

SELECT "ID_TagData", value
       INTO avg_id, val 
FROM "SC_Tag"."T_TagData"
WHERE "F_TagName_ID" = 192
  AND "F_Date">(now()- interval '12:00:00')
ORDER BY "F_Date" DESC LIMIT 1;

Answer 1

It is possible, but in plpgsql INTO is written to variables at the end of the query.

SELECT "ID_TagData", value
FROM "SC_Tag"."T_TagData"
WHERE "F_TagName_ID" = 192
  AND "F_Date">(now()- interval '12:00:00')
ORDER BY "F_Date" DESC LIMIT 1
INTO avg_id, val;

And here INTO in the middle of request is a selection in the table (in one).