Re: Stored Procedure / function and their result

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.