Re: select into multiple variables - Mailing list pgsql-general

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;