Re: plpython does not honour max-rows

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: plpython does not honour max-rows
Дата
Msg-id 711512C7-2BC2-4901-A368-6A5A23023F72@yesql.se
обсуждение исходный текст
Ответ на plpython does not honour max-rows  (Kieran McCusker <kieran.mccusker@gmail.com>)
Ответы Re: plpython does not honour max-rows  (Kieran McCusker <kieran.mccusker@gmail.com>)
Список pgsql-bugs
> On 2 May 2023, at 12:30, Kieran McCusker <kieran.mccusker@gmail.com> wrote:

> I came across this when developing a sampling function using plpy.execute that needs to be able to sample zero rows.
Whatactually happens is that zero is ignored for max-rows and all rows are returned. 

A max_rows of less than or equal to zero is IIRC interpreted as "fetch all
rows".  I think this works as intended, is it documented anywhere to work in
another way?

--
Daniel Gustafsson




В списке pgsql-bugs по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files
Следующее
От: Kieran McCusker
Дата:
Сообщение: Re: plpython does not honour max-rows