In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 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; ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
