/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 vote208 views1 answer
Clear screen command in psql
SQL
0 vote291 views1 answer
Sql trigger to call stored procedure with parameters
SQL
2 votes215 views3 answers
How to check current user in mySQL
SQL
0 vote212 views1 answer
Select * from mysql.proc
SQL
0 vote220 views1 answer
Hour differeence in mysql
SQL
0 vote255 views1 answer
Capabilities of sql select statements
SQL
1 vote214 views2 answers
Postgres copy table from one schema to another
SQL
0 vote202 views1 answer
What is SQL data store?
SQL
1 vote199 views1 answer
Crontab every month
SQL
1 vote191 views1 answer
Pv mysql import
SQL