/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

2 votes116 views2 answers
Checking data type in sql server
SQL
1 vote119 views1 answer
Spark sql convert string to date
SQL
5 votes97 views1 answer
Sysdate in oracle sql
SQL
0 vote108 views1 answer
Postgresql check total storage
SQL
10 votes101 views1 answer
Oracle view dependencies
SQL
1 vote122 views1 answer
Sql list all procedures
SQL
1 vote134 views2 answers
Install sql server management studio ubuntu
SQL
1 vote49 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote113 views1 answer
Sql server union if table exist
SQL
12 votes98 views4 answers
How to take database dump in postgresql
SQL