2013/8/20 David E. Wheeler <[email protected]> > On Aug 20, 2013, at 2:41 PM, Pavel Stehule <[email protected]> > wrote: > > > yes, in this context you should not use a PERFORM > > > > PL/pgSQL protect you before useless queries - so you can use a CTE > without returned result directly or CTE with result via PERFORM statement > (and in this case it must be unmodifing CTE). > > > > Sorry, I don't see any problem - why you return some from CTE and then > you throw this result? > > I am passing the values returned from a CTE to a call to pg_notify(). I do > not care to collect the output of pg_notify(), which returns VOID. >
it is little bit different issue - PL/pgSQL doesn't check if returned type is VOID - it can be allowed, I am thinking. So check of empty result can be enhanced. Regards Pavel > > Best, > > David > >
