/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

3 votes202 views2 answers
Df to sql pandas sql achemy
SQL
0 vote182 views1 answer
Oracle search columns in schema
SQL
0 vote252 views1 answer
Using distinct and count together in sql
SQL
32 votes230 views6 answers
Rename column mysql
SQL
0 vote191 views1 answer
Sql select upcoming birthdays
SQL
1 vote209 views2 answers
Procedure syntax
SQL
0 vote223 views1 answer
Create table split string function in sql server
SQL
0 vote222 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote194 views1 answer
Use between operator in mysql
SQL
17 votes188 views6 answers
Mysql import sql file
SQL