Re: how to make function to return multiple fields??

<jeffchirco_at_gmail.com> wrote in message news:1115845179.717871.34470_at_g14g2000cwa.googlegroups.com...
> Is there a way for a function to return multiple columns and multiple
> rows
>
> For simplicity, say I have a table EMPLOYEE like below;
>
> dbid dbfname dblname
> 1 Jeff Chirco
> 2 Dave Quackenbush
> 3 Warren Fitzgerald
> 4 Josh Freeze
> 5 Joe Escalante
>
> And I want my function to return all the contents of this table. How
> would I do this? Is it possible?
> My real function accepts a bunch of paremeters and does a lot of others
> things to get the results I want.
>

look into pipeline functions

++ mcs Received on Wed May 11 2005 - 23:09:11 CEST