/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 vote359 views1 answer
Oracle grant select on schema
SQL
5 votes377 views6 answers
In operator sql
SQL
8 votes370 views1 answer
Ltrim sql
SQL
3 votes359 views2 answers
Postgres show table schema
SQL
0 vote348 views1 answer
Describe in sqlite3
SQL
0 vote366 views1 answer
Authentication modes in sql server
SQL
0 vote387 views1 answer
Drop domain postgresql
SQL
3 votes345 views1 answer
Select table column in sql
SQL
0 vote342 views1 answer
Change default schema sql server
SQL
5 votes376 views1 answer
Mysql last day of next month
SQL