Re: SELECTing from a function where i don't want the results - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: SELECTing from a function where i don't want the results
Date
Msg-id 20200708125234.GA21649@depesz.com
Whole thread Raw
In response to SELECTing from a function where i don't want the results  (Wells Oliver <wells.oliver@gmail.com>)
Responses SELECTing from a function where i don't want the results
List 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




pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Encryption password for Backup
Next
From: Marlene Villanueva
Date:
Subject: SELECTing from a function where i don't want the results