agensgraph icon indicating copy to clipboard operation
agensgraph copied to clipboard

ROW_COUNT expected to show # of created/updated rows

Open jshen-r7 opened this issue 1 year ago • 0 comments

ROW_COUNT reports the number of updated or created rows in a plpgsql block, but seems not to work with any Agensgraph DML.

test=*# DO $$
DECLARE
    dummy INTEGER;
BEGIN
    CREATE (m {"name": 'M1'});

    GET DIAGNOSTICS dummy = ROW_COUNT;

    RAISE NOTICE 'Number of rows created: %', dummy;
END;
$$;
NOTICE:  Number of rows created: 0
DO

jshen-r7 avatar May 22 '24 18:05 jshen-r7