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