/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 vote177 views1 answer
Table infromation in sql server
SQL
0 vote215 views1 answer
How to to get time in sql
SQL
0 vote252 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote226 views1 answer
Mysql default port
SQL
0 vote163 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote187 views1 answer
Ilike for date postgres
SQL
0 vote181 views1 answer
Deny select insert update delete sql
SQL
4 votes208 views1 answer
SQL find text in SP
SQL
1 vote286 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote185 views1 answer
Initcap in sql
SQL