/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 votes112 views1 answer
Oracle sql merge
SQL
-2 votes113 views1 answer
Create trigger syntax
SQL
0 vote113 views1 answer
Db format in quotation
SQL
0 vote103 views1 answer
Oracle gather table statistics
SQL
2 votes115 views1 answer
Sqlite indexes
SQL
8 votes117 views2 answers
Safe update mode in mysql
SQL
0 vote111 views1 answer
Why mysql is used?
SQL
0 vote112 views2 answers
Temp Space
SQL
0 vote106 views1 answer
Sql get count without group by
SQL
0 vote125 views1 answer
Sql output select
SQL