Re: [SQL] Selecting a non-locked row.

2003-01-19 Thread Kurt Roeckx
On Sun, Jan 19, 2003 at 01:26:10PM -0800, Josh Berkus wrote: > Kurt, > > > I have a table with records in, and they either still need to be > > processed or not. Several people will be using the table at the > > same time. > > > > I was thinking about using a select for update limit 1, but

[SQL] Selecting a non-locked row.

2003-01-19 Thread Kurt Roeckx
I'm in the process of writing an application, and I'm not sure how to properly solve it. I have a table with records in, and they either still need to be processed or not. Several people will be using the table at the same time. I was thinking about using a select for update limit 1, but th