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

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: SELECTing from a function where i don't want the results
Дата
Msg-id 20200708125234.GA21649@depesz.com
обсуждение исходный текст
Ответ на SELECTing from a function where i don't want the results  (Wells Oliver <wells.oliver@gmail.com>)
Ответы SELECTing from a function where i don't want the results  (Marlene Villanueva <villanuevamarlene906@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Encryption password for Backup
Следующее
От: Marlene Villanueva
Дата:
Сообщение: SELECTing from a function where i don't want the results