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

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: SELECTing from a function where i don't want the results
Date: 2020-07-07 22:34:31
Message-ID: CAOC+FBXnaxi1yiEv=mL2J1tbnsLfqoneNOnikiQFobdEv=DaWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2020-07-07 22:38:18 Re: SELECTing from a function where i don't want the results
Previous Message Mahesh mana 2020-07-04 05:03:04 Work load manager...