select into multiple variables - Mailing list pgsql-general

From SunWuKung
Subject select into multiple variables
Date
Msg-id MPG.1e3088f9e44ccb3989687@news.postgresql.org
Whole thread Raw
List pgsql-general
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.

pgsql-general by date:

Previous
From: John McCawley
Date:
Subject: Re: regarding triggers
Next
From: SunWuKung
Date:
Subject: Re: select into multiple variables