Thread: 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