/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

0 vote115 views1 answer
Table or view does not exist
SQL
11 votes118 views2 answers
Safe mode off mysql
SQL
0 vote160 views1 answer
Postgres extract number from string
SQL
0 vote139 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote112 views5 answers
Select concat alter table mysql
SQL
0 vote119 views1 answer
Sql cheetsheet
SQL
0 vote128 views2 answers
Mysql dump structure only
SQL
0 vote128 views1 answer
Groupby sort sql hive
SQL
0 vote127 views1 answer
Oracle to_number
SQL
0 vote126 views1 answer
Database traccar
SQL