Search Postgresql Archives

How to find out if row was modified by EXECUTE UPDATE ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello.
Doesn't this work in plpgsql functions?

EXECUTE 'UPDATE mytable set ... ...'
IF FOUND THEN
       do stuff....
END IF;

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux