/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 vote384 views1 answer
Sql headers delphi
SQL
1 vote376 views1 answer
Sql dcl
SQL
0 vote366 views1 answer
Alter table name including schema
SQL
2 votes359 views1 answer
How to show the whole table in sql
SQL
4 votes357 views2 answers
Bulk kill mysql processlist
SQL
0 vote376 views1 answer
How to select only a certain date sql
SQL
0 vote337 views1 answer
Sql compound operators
SQL
0 vote348 views1 answer
Get last updated row sql server
SQL
0 vote364 views1 answer
How to connect pgadmin with excel
SQL
0 vote361 views1 answer
Mysql type for large numbers with many decimal
SQL