Is there a way of doing:
RETURNS INTEGER, CHAR(5), VARCHAR(200),.....
IE return multiple values from a PL/PGSQL function?
(From what I can see so far, you only have 1 return field - although that can be a rowtype or record)
I am converting Informix functions, and returning multiple columns was allowed - I need to be able to do the same/similar in PostGre. What's the best way?
(Typically the functions return an error code, error text (that are not table based - ie are built in the function and not selected from a table) and two or three columns from a table).
Regards,
Steve Tucknott
ReTSol Ltd
DDI: 01903 828769
|