Locking rows

[stressman]

Hi
i've allready find the way to lock a table by the command
lock table in exclusive mode
but is there a way to lock a part of a table, just a few rows, and for a determinated time.
thanks for your attention and i hope for your help

 

[Dagon]

select from table
where ....
for update (of column)