Re: select into multiple variables

[SunWuKung <Balazs.Klein@xxxxxxxxxx>]

In article <MPG.1e3088f9e44ccb3989687@xxxxxxxxxxxxxxxxxxx>, 
Balazs.Klein@xxxxxxxxxx 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;