Monthly Archives: October 2017

Postgresql-Get the number of rows affected

You will find a way below to get the number of rows affected by an UPDATE or a DELETE statement.   CREATE FUNCTION update_foobar(id INT, field1 VARCHAR(40)) RETURNS INTEGER LANGUAGE plpgsql AS $$ DECLARE — some variables declarations BEGIN — … Continue reading

Posted in General | Leave a comment