On Mon, Mar 19, 2007 at 01:54:14PM +0100, Alain Roger wrote:
> Hi,
>
> I would like to know if there is a better way how to retrieve result from a
> stored procedure (function) than to use 'AS res(col1 varchar, col2
> timestamp,..)'
Sure, create a type with the relevent field name and use that in you
function declaration:
CREATE TYPE mytype AS S res(col1 varchar, col2 timestamp,..);
> for example, here is a stored procedure :
> CREATE OR REPLACE FUNCTION SP_A_003(username VARCHAR)
> RETURNS SETOF RECORD AS
And change that to:
RETURNS SETOF mytype AS
And you're done.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.