On 10/7/24 08:15, PetSerAl wrote:
How to reliable get cursor name which cause invalid_cursor_name error?
postgres=# CREATE FUNCTION value_from_cursor_unsafe(cursor_name text)
RETURNS integer
postgres-# STRICT LANGUAGE plpgsql
postgres-# AS $$
postgres$# DECLARE
postgres$# cursor CONSTANT r
How to reliable get cursor name which cause invalid_cursor_name error?
postgres=# CREATE FUNCTION value_from_cursor_unsafe(cursor_name text)
RETURNS integer
postgres-# STRICT LANGUAGE plpgsql
postgres-# AS $$
postgres$# DECLARE
postgres$# cursor CONSTANT refcursor NOT NULL := cursor_name;
po