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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
