/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

20 votes155 views1 answer
Get all table name in sql through php
SQL
15 votes169 views3 answers
Mysql update add to existing value
SQL
0 vote181 views1 answer
Plsql find location of procedure
SQL
0 vote187 views1 answer
How to get nth number in sql
SQL
0 vote195 views1 answer
Sort by
SQL
1 vote174 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
5 votes184 views4 answers
Mysql update column with value from another table
SQL
3 votes161 views2 answers
Current year sql
SQL
3 votes170 views1 answer
Create a table with an id in mysql
SQL
0 vote176 views1 answer
Is not sql
SQL