/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 vote172 views1 answer
Oracle job class
SQL
5 votes178 views3 answers
Mysql remove unique constraint
SQL
1 vote249 views3 answers
Date_add mysql
SQL
0 vote162 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote224 views1 answer
Varchar plsql
SQL
0 vote238 views1 answer
Mac os zsh: command not found: mysql
SQL
2 votes173 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
11 votes163 views4 answers
MYSQL LOGIN
SQL
1 vote269 views2 answers
Truncate table sqlite
SQL
0 vote183 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL