dblink / plpgsql - definition list cheats for record returning functions?
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
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
--- Richard Huxton <dev@archonet.com> 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 expect.
It's a dblink C function that returns RECORD so I just wanted to create a view or
type to help it reference the return data as ( TYPE ) rather than typing a
definition list as ( id integer, .. ) each time for each query.
____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index