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

On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote:

> > 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. :)

But that last does exactly that. Doesn't even return a null. Give it a quick
go, skip the delete statement obviously, and see. You'll get something like:

?
-------

(0 rows)

--
Nigel J. Andrews