Re: [GENERAL] dblink / plpgsql - definition list cheats for record

2006-11-09 Thread Matthew Peter
--- Richard Huxton wrote: > Matthew Peter wrote: > > Is there any way to use CREATE TYPE or an VIEW/TABLE defintion list instead > > of > > manually defining it? > > Yes, just define your function as returning that type rather than > RECORD. That way the calling context will know what to expe

Re: [GENERAL] dblink / plpgsql - definition list cheats for record

2006-11-09 Thread Richard Huxton
Matthew Peter wrote: Is there any way to use CREATE TYPE or an VIEW/TABLE defintion list instead of manually defining it? Yes, just define your function as returning that type rather than RECORD. That way the calling context will know what to expect. -- Richard Huxton Archonet Ltd -

[GENERAL] dblink / plpgsql - definition list cheats for record returning functions?

2006-11-08 Thread Matthew Peter
Is there any way to use CREATE TYPE/VIEW/TABLE defintion list instead of manually defining the result types in the calling sql? Thanks __ Sponsored Link Talk more and pay less. Vonage can save you up to

[GENERAL] dblink / plpgsql - definition list cheats for record returning functions?

2006-11-08 Thread Matthew Peter
Is there any way to use CREATE TYPE or an VIEW/TABLE defintion list instead of manually defining it? Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. http://new.mail.yahoo.com