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

Nigel J. Andrews wrote:

>
>
>
> Try returning an integer but returning a null for that integer...on the other
> hand I see you're using sql as the language and I don't know how that would
> work.

I tried that and it works. I changed the function body to do a query
which returns null. The problem only appears if the return type is void.

>
> Have you looked at plpgsql? Perhaps that is acceptable for you, in which case:
>
> create function funcF ( ) returns integer as '
> begin
> delete from blah;
> return null;
> end;
> ' as language 'plpgsql';
>
> select * from funcF();
>

Yeap, it works, but you specified integer as the return type :)

I'd like to have the return type as void and be possible to call it with
select * from funcF();

Thanks Nigel.

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