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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SELECTing from a function where i don't want the results
Date: 2020-07-08 12:52:34
Message-ID: 20200708125234.GA21649@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jul 07, 2020 at 03:34:31PM -0700, Wells Oliver wrote:
> Vanilla SQL script calls a plpgsql function to delete some number of rows
> from three tables:
>
> SELECT mydelete(r) FROM sometable;

select count( mydelete(r) ) from sometable;

this will return just one row regardless of how many rows are in
sometable.

Best regards,

depesz

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marlene Villanueva 2020-07-08 13:49:33 SELECTing from a function where i don't want the results
Previous Message Ron 2020-07-08 12:26:35 Re: Encryption password for Backup