/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 vote342 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
8 votes295 views1 answer
Similarities between ddl and dml
SQL
0 vote352 views1 answer
Sql script get all stored procedures from database
SQL
0 vote355 views2 answers
Add new column after in sql
SQL
1 vote365 views1 answer
Dropping a constraint in ms sql
SQL
1 vote363 views1 answer
Sql where max date
SQL
5 votes317 views4 answers
Describe table postgres
SQL
3 votes320 views3 answers
Mysql get table size
SQL
0 vote426 views1 answer
Sqlite display headers on columns
SQL
1 vote351 views1 answer
Get create table query existing table mysql
SQL