Re: SELECTing from a function where i don't want the results

[Wells Oliver <wells.oliver@xxxxxxxxx>]

Yeah. I just kinda want a silent SELECT since the function I'm calling just deletes, and I don't care about the output.

I'm guessing this is just something I need to get over.

On Tue, Jul 7, 2020 at 5:07 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Tuesday, July 7, 2020, Holger Jakobs <holger@xxxxxxxxxx> wrote:

You could combine the result with a NULL value, as any operations with NULL result in NULL.

SELECT mydelete(r) + NULL FROM sometable;

So now you have 100 rows containing null (assuming that indeed function result + unknown means something and you don’t just get an error) which is no better than what is the probably 100 rows of void output the OP is complaining about.

David J.

--

Wells Oliver
wells.oliver@xxxxxxxxx