/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 vote203 views1 answer
Mysql get last 2 month data
SQL
1 vote185 views1 answer
Set statistics on in ssms
SQL
0 vote181 views1 answer
Oracle create package body
SQL
0 vote181 views1 answer
Mysql update sequence with order by
SQL
16 votes209 views6 answers
Python sqlite
SQL
20 votes206 views6 answers
Mysql reset auto increment
SQL
0 vote184 views1 answer
Mysql group rows with same value
SQL
0 vote195 views1 answer
Sum values by month mariadb
SQL
5 votes182 views2 answers
Oracle show procedures
SQL
0 vote212 views1 answer
Ajouter une clé etrangere mysql
SQL