/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 vote101 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote108 views1 answer
Oracle session statistics
SQL
0 vote102 views2 answers
Uninstall postgresql mac
SQL
19 votes108 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
4 votes127 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote102 views2 answers
How to search date in sql query
SQL
0 vote116 views1 answer
Psql show db
SQL
1 vote105 views1 answer
Postgresql create table with timestamp
SQL
0 vote108 views1 answer
SQL check if record exist
SQL
0 vote103 views1 answer
Sql missing values
SQL