var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: postgresql procedure & returning affected row
I like to know if a procedure function can be created to return the number of rows been affected from deleting rows from a table
However the above procedure does not work.
CREATE OR REPLACE FUNCTION deleteTest(id INT) RETURNS INT AS $BODY$
deletedRow := (DELETE FROM test WHERE test_id = id);
$BODY$ LANGUAGE plpgsql;
Can some one help?