/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

1 vote164 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
8 votes142 views1 answer
How to remove tables from postgresql
SQL
0 vote164 views1 answer
Access mysql database docker container shell
SQL
0 vote160 views1 answer
Closure in sql
SQL
1 vote179 views4 answers
How to check table in postgresql from terminal
SQL
6 votes160 views1 answer
Postgresql add enum value
SQL
-1 vote179 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote176 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote153 views1 answer
Désinstaller postgresql linux
SQL
1 vote174 views2 answers
Full join
SQL