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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
