Re: Function return rows?

От:

Allan Engelhardt <allane@cybaea.com>

Дата:

4 октября 2001 г. в 17:04:36

Pat M wrote:

> Can I use a function to execute a query and return a row or set of rows?

No.  Consider using temporary tables if you must do this.

> If
> so, can you point me to some examples or perhaps give me an example of a
> function that would do roughly the same thing as:
>
> select * from mytable where mytable.name ~* 'aname';
>
> I can't seem to find any examples that return rows, just single ints and
> bools and stuff.

Function return rows?

От:

"Pat M" <pmeloy@removethispart.home.com>

Дата:

2 октября 2001 г. в 10:55:51

Can I use a function to execute a query and return a row or set of rows? If
so, can you point me to some examples or perhaps give me an example of a
function that would do roughly the same thing as:

select * from mytable where mytable.name ~* 'aname';

I can't seem to find any examples that return rows, just single ints and
bools and stuff.