/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

6 votes149 views2 answers
Mysql get yesterday
SQL
0 vote140 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
1 vote152 views1 answer
Sqlalchemy order by descending
SQL
-1 vote148 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote151 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote166 views1 answer
Mysql concatenate select results
SQL
6 votes106 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote170 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote163 views1 answer
Enable sql server full text indexing
SQL
0 vote180 views1 answer
Compress sql file database ubuntu
SQL