agensgraph
agensgraph copied to clipboard
ROW_COUNT expected to show # of created/updated rows
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