/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 votes186 views5 answers
Install postgresql 10 centos 7
SQL
0 vote170 views1 answer
Generate random & unique mysql string
SQL
8 votes119 views1 answer
Sql remove characters from string right
SQL
0 vote127 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote126 views1 answer
Oracle locked objects
SQL
0 vote125 views1 answer
Is numeric in sql
SQL
0 vote130 views1 answer
Oracle list datafiles
SQL
0 vote150 views1 answer
Order child below the parent in mysqli
SQL
0 vote129 views1 answer
Sql with example
SQL
0 vote163 views1 answer
000webhost database values insert
SQL