/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 vote218 views1 answer
Show database not empty tables postgres
SQL
34 votes228 views5 answers
Oracle alter table add column
SQL
-1 vote215 views1 answer
Sql add column bit
SQL
0 vote220 views1 answer
Count number of entires by months sql
SQL
0 vote221 views1 answer
Except in sql alchemy
SQL
-1 vote210 views1 answer
MYSQL stored procedure select from
SQL
0 vote207 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote230 views1 answer
Closure in sql
SQL
0 vote229 views1 answer
Sql select column name like from multiple tables
SQL
0 vote229 views1 answer
Sql select upcoming birthdays
SQL