/SQL/Postgresql stored procedure update table values

Postgresql stored procedure update table values

CREATE OR REPLACE FUNCTION change_account_email(
  IN oldAddr VARCHAR(50),
  IN newAddr VARCHAR(50))
RETURNS INTEGER AS 
$$
DECLARE
  rcount INTEGER DEFAULT 0;
BEGIN
  UPDATE accounts
     SET a_email = newAddr
   WHERE a_email = oldAddr;
   GET DIAGNOSTICS rcount = ROW_COUNT;
   RETURN rcount;
END;
$$
LANGUAGE plpgsql;

Source: stackoverflow.com

Similar codes

7 votes271 views2 answers
Get database size mysql
SQL
0 vote298 views1 answer
Dbms_output sql developer
SQL
1 vote299 views1 answer
Create new index takes long time postgresql
SQL
12 votes288 views4 answers
Mysql ifnull
SQL
6 votes291 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote296 views1 answer
Count database access django
SQL
2 votes308 views2 answers
Mysql count rows returned
SQL
0 vote283 views1 answer
Postgresql print variable
SQL
1 vote311 views1 answer
Group_concat order by
SQL
1 vote303 views1 answer
Oracle sequence last_number
SQL