Re: Why select * from function doesn't work when function

Nigel J. Andrews wrote:

> On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote:
> 
> 
>>>select * from funcF();
>>>
>>
>>Yeap, it works, but you specified integer as the return type :)
> 
> 
> Yes, that's because I knew the void wouldn't work. :]
> 

:)

> How's this for an alternative if you really don't want any rows returned:
> 
> create function fincF ( )  returns setof integer as '
>  begin
>    delete from blah;
>    return;
>  end;
> ' language 'plpgsql';
> 
> 

This works, but what I really want is not to return any rows. I mean, 
the problem is not return null, but the error I get if I select * from 
voidfunction.

I just wanted void functions behave like others when called as select * 
from voidfunction  So I dont have to do select voidfunction. :)



-- 
Regards,

Francisco Figueiredo Jr.

------
"My grandfather once told me that there are two
kinds of people: those
who work and those who take the credit. He told me
to try to be in the
first group; there was less competition there."
- Indira Gandhi