Re: select into multiple variables

In article <MPG(dot)1e3088f9e44ccb3989687(at)news(dot)postgresql(dot)org>,
Balazs(dot)Klein(at)axelero(dot)hu says...
> 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.
>

ugh, sorry, found it

SELECT INTO
instrumentheaderid_arg, subjectgroupheaderid_arg
instrumentnormheader.instrumentheaderid,
instrumentnormheader.subjectgroupheaderid
FROM
public.instrumentnormdetail
INNER JOIN public.instrumentnormheader ON
(public.instrumentnormdetail.instrumentnormheaderid =
public.instrumentnormheader.instrumentnormheaderid)
WHERE instrumentnormdetailid=instrumentnormdetailid_arg;