/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 vote265 views1 answer
How to unlock table in mysql
SQL
0 vote262 views2 answers
Mysql regexp match word
SQL
0 vote285 views1 answer
Drop tables from local database postgres pgadmin
SQL
8 votes266 views1 answer
Today minus 15 days postgresql
SQL
0 vote271 views1 answer
<sql:datasource var="Snapsho"
SQL
6 votes305 views3 answers
Psql show columns of table
SQL
0 vote280 views1 answer
Oracle list datafiles
SQL
0 vote247 views2 answers
Which MySQL statement is used to delete data from a database
SQL
-1 vote270 views1 answer
Concat two columns in sql server
SQL
0 vote286 views1 answer
Authentication modes in sql server
SQL