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