CREATE PROCEDURE test(
@lookup char(50))
WITH ENCRYPTION AS BEGIN
-- ... a bunch of code to do some lookup, and then ...
SELECT
@Result1 AS Result1,
@Result2 AS Result2,
@Result3 AS Result3,
@Result4 AS Result4
END
GO
and then when I call this procedure, I get a result row (like it came
from a SELECT on a table) which has the columns neatly labeled with
'Result1', 'Result2', etc. Note that these column labels are rather
arbitrary and not necessarily associated with a single table or
perhaps even any existing column in a table.
I think what you are looking for is SetOF functions.
http://www.postgresql.org/docs/8.0/interactive/functions-srf.html
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
