/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 vote181 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote184 views3 answers
Reset sql primary key
SQL
2 votes171 views1 answer
How to find constraints on a table in oracle
SQL
5 votes173 views1 answer
Oracle nls parameters
SQL
0 vote175 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote174 views3 answers
Osx stop mysql service
SQL
0 vote179 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
10 votes174 views2 answers
Sql rtrim
SQL
-1 vote178 views2 answers
Postgresql get last 10 records
SQL
6 votes181 views1 answer
T-sql test if table exists
SQL