Selecting multiple values into variables

[pabowen]

I am trying to figure out how to use a select statement to populate multiple variables.

I am very familiar with how to populate one variable using select. ie.

Select xcode into Code from course;

But I would like to populate multiple codes, and have tried a statement such as this.

Select xcode into Code, xname into Name from Course;

But have so far been unsuccessful. Can anyone out there show me the light?

Thanks in advance,
Patrick

 

[PGoRule]

SELECT a,b,c INTO x,y,z FROM ABC.

Sharing the best from my side...

--Prashant--