Hi all,
I need to mark a row with a value in a column, but first i need to select
the first row without this mark. But in some concurrents cases i mark the
row twice. How can i lock the row to avoid others session get it?
TABLE TICKET
TICKET_NUMBER | MARK
00001 | 1
00002 | 0
I need to select the first row with 0 in MARK column and then mark it with
1.
regards,
Flavio Suguimoto
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
