--- Richard Huxton <dev@xxxxxxxxxxxx> 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