/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

1 vote223 views2 answers
Replace text in sql
SQL
0 vote230 views1 answer
Raven ql select count
SQL
0 vote289 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote368 views1 answer
Dublicate row sql
SQL
0 vote231 views1 answer
Sql where part of string match
SQL
0 vote228 views1 answer
Inserting data into different tables at once in oracle sql
SQL
3 votes255 views2 answers
Sql add year to date
SQL
4 votes226 views1 answer
Force drop all tables postgres
SQL
1 vote237 views2 answers
Grab part of a string sql
SQL
1 vote223 views1 answer
Sql server read uncommitted
SQL