nowait

nowait

Hi All!

Exist in the PGSQL  Oracle like 
SELECT * FROM TABLEX WHERE ID = 12345
 FOR UPDATE NOWAIT  statement???

FOR UPDATE try lock record(s) of table (and wait forever).
NOWAIT if record is locked by another user then create an error.

Thanks for all ideas!

thx 
Pepe