/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 votes256 views1 answer
Sql ends with string
SQL
1 vote275 views1 answer
Mysql show attributes of a table
SQL
10 votes274 views4 answers
Else if mysql
SQL
1 vote232 views1 answer
Minus vs intersect in sql
SQL
3 votes291 views3 answers
Create table in SQL Server
SQL
0 vote263 views1 answer
Python sqlalchemy connection show server
SQL
3 votes246 views2 answers
Coalesce mysql
SQL
0 vote267 views1 answer
Mysql workbench format date
SQL
7 votes258 views1 answer
Sql server convert string to date
SQL
1 vote247 views1 answer
Return size of tables in mysql
SQL