I have a select statement in a pgpsql function that returns two columns
and a single row.
I would like to place the two values into two variables in a single
statement, but so far I couldn't find out what is the syntax for that.
I tried a couple of combinations of this but had no luck:
SELECT INTO
instrumentheaderid_arg, subjectgroupheaderid_arg,
instrumentnormheader.instrumentheaderid,
instrumentnormheader.subjectgroupheaderid
FROM
instrumentnormheader
WHERE instrumentnormheaderid=3
Thanks for the help.
B.