/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 vote330 views1 answer
Xampp import sql file command line
SQL
11 votes333 views1 answer
Mysql text type max length
SQL
0 vote351 views1 answer
Sql delete caracter list
SQL
0 vote376 views2 answers
What is rownum in oracle
SQL
1 vote330 views2 answers
Sql select only row with the max date
SQL
0 vote327 views2 answers
Sql max count
SQL
24 votes325 views5 answers
Sql server insert into select
SQL
0 vote348 views1 answer
Shrink database file in sql server
SQL
2 votes337 views1 answer
Sql OR
SQL
0 vote332 views1 answer
Sql server datetime
SQL