/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 vote113 views1 answer
How to select random rows from table
SQL
0 vote114 views1 answer
Postgresql where clause not working
SQL
-1 vote131 views1 answer
Ms sql select datetime as date
SQL
0 vote205 views1 answer
Install ms sql server management studio
SQL
0 vote119 views1 answer
Reset postgresql password windows
SQL
0 vote122 views1 answer
Oracle c# multiple update sql
SQL
1 vote140 views1 answer
Mysql select all and rename one
SQL
1 vote122 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote82 views1 answer
Query for maximum salary
SQL
4 votes120 views1 answer
Create table if not exist in sqlite
SQL