/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

2 votes139 views1 answer
Sql select min value from multiple columns
SQL
0 vote184 views1 answer
Get who is hired in february in sql
SQL
1 vote176 views2 answers
Find a column in all tables mysql
SQL
6 votes193 views1 answer
Allsource oracle
SQL
1 vote174 views1 answer
Get rows affected mysql python
SQL
0 vote232 views2 answers
Find lowest number in sql
SQL
0 vote130 views1 answer
Bigquery information_schema schema all columns
SQL
10 votes194 views1 answer
All_dependencies
SQL
0 vote191 views1 answer
Remove transient options sql wordpress
SQL
1 vote167 views1 answer
Error code 1055
SQL