Hello 2010/3/8 A B <gentosa...@gmail.com>: > Hello. > Doesn't this work in plpgsql functions? > > EXECUTE 'UPDATE mytable set ... ...' > IF FOUND THEN > do stuff.... > END IF; >
it doesn't work - you have to use GET DIAGNOSTICS statement GET DIAGNOSTICS integer_var = ROW_COUNT; http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS regards Pavel Stehule > It seems it always evaluate to false in the if statement, Isn't found > used to see if an update has modified rows? > > Are there any alternatives to selecting the row and see if the values > are set to see if the update worked? > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
