Re: plpython does not honour max-rows
| От | Kieran McCusker |
|---|---|
| Тема | Re: plpython does not honour max-rows |
| Дата | |
| Msg-id | CAGgUQ6GBpw-vkzxuuTk3au8Hq+YezG5sv3yR=YjE3CbOqp-a3Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: plpython does not honour max-rows (Daniel Gustafsson <daniel@yesql.se>) |
| Ответы |
Re: plpython does not honour max-rows
|
| Список | pgsql-bugs |
Thanks for the quick response. Chapter 46.6.1 says that max-rows is an optional row limit. Unless I missed it there is nothing in the documentation about zero meaning all rows. Wouldn't it rather be like SQL LIMIT 0 meaning all rows?
Anyway it was surprising gotcha, but of course easy to code around.
Kieran
On Tue, 2 May 2023, 12:01 Daniel Gustafsson, <daniel@yesql.se> wrote:
> 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. What actually 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 по дате отправления: