/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 vote249 views1 answer
How much space does sql server take per row
SQL
0 vote269 views2 answers
How to get max from each department in sql
SQL
1 vote239 views1 answer
Mysql batch insert
SQL
0 vote235 views1 answer
Show size of all tables postgres
SQL
1 vote236 views1 answer
Mysql check table exists
SQL
6 votes267 views6 answers
Rename column postgres
SQL
0 vote250 views1 answer
What is initial catalog in sql connection string
SQL
1 vote250 views1 answer
T-SQL / AZURE Reseed
SQL
3 votes229 views1 answer
Mssql remove column
SQL
22 votes246 views3 answers
SQL CHEATSHEET
SQL