/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 vote216 views1 answer
Plpgsql create function
SQL
1 vote174 views1 answer
Sql comment header
SQL
0 vote194 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote176 views1 answer
Oracle last connection
SQL
0 vote181 views1 answer
Sql cheetsheet
SQL
1 vote183 views2 answers
Mysql remove first and last character from string
SQL
4 votes221 views1 answer
Sql select limit range
SQL
0 vote186 views2 answers
Tsql row number
SQL
3 votes163 views3 answers
Print in pl sql
SQL
5 votes172 views2 answers
Oracle show procedures
SQL