Daniel Verite schrieb am 19.11.2020 um 13:06:
>> arthur=> select * from get_results();
>> get_results
>> --------------------
>> <unnamed portal 1>
>> <unnamed portal 2>
>
> Friendlier names may be used by assigning them in the function,
> i.e. plpgsql does support:
>
> declare
> c1 refcursor := 'mycursorname';
>
> Then the caller might simply hardcode the cursor names in the FETCH
> statements rather than building them dynamically at runtime.
Ah, cool.
That is indeed much easier to work with (in case I ever have to)
Thomas