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

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

SELECT mydelete(r) + NULL FROM sometable;

Am 08.07.20 um 00:34 schrieb Wells Oliver:
> Vanilla SQL script calls a plpgsql function to delete some number of
> rows from three tables:
>
> SELECT mydelete(r) FROM sometable;
>
> Where sometable contains maybe 100+ records. This causes the results
> from the function (integer of number of rows removed) to be displayed
> in the output, like you'd kinda expect with a SELECT call, except I
> don't want to see it all, I just want the function quietly executed
> and rows removed.
>
> Can I accomplish this?
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <mailto:wellsoliver(at)gmail(dot)com>

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012