Re: plpython does not honour max-rows - Mailing list pgsql-bugs

From Daniel Gustafsson
Subject Re: plpython does not honour max-rows
Date
Msg-id 711512C7-2BC2-4901-A368-6A5A23023F72@yesql.se
Whole thread Raw
In response to plpython does not honour max-rows  (Kieran McCusker <kieran.mccusker@gmail.com>)
Responses Re: plpython does not honour max-rows  (Kieran McCusker <kieran.mccusker@gmail.com>)
List 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 by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files
Next
From: Kieran McCusker
Date:
Subject: Re: plpython does not honour max-rows