On Tue, Nov 21, 2023 at 11:31 AM Joan Pujol <joanpujol@xxxxxxxxx> wrote:
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?
Producing a single row single column result and then storing it into a variable should leverage parallelism if the query is amenable to it.
David J.