In article <MPG.1e3088f9e44ccb3989687@news.postgresql.org>,
Balazs.Klein@axelero.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;