Re: Retrieve results in PostgreSQL stored procedure allowing query parallelism

Thanks, David. If I try to do something like: EXECUTE SELECT INTO ARRAY_AGG(t.*) INTO result_records Would internally use cursors too and have the same restrictions? Cheers, On Tue, 21 Nov 2023 at 19:22, David G. Johnston wrote: > > On Tue, Nov 21, 2023, 11:10 Joan Pujol wrote: >&g

Retrieve results in PostgreSQL stored procedure allowing query parallelism

est way to execute the query, retrieve all results in memory, and process them inside the stored procedure? -- Joan Pujol