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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
