Updating selected record - Mailing list pgsql-sql

From Levente Lajko
Subject Updating selected record
Date
Msg-id 6B588E329B79AB4A919D629A75F5338F041D73@george.topline.co.uk
Whole thread Raw
Responses Re: Updating selected record  (John DeSoi <desoi@pgedit.com>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I have problem with a table from where I select specific field data </span></font><p
class="MsoNormal"style="text-indent:36.0pt"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">SELECTfiled1, field2 FROM tbl WHERE progress = 1 LIMIT 1</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> through a perl script or multiple instances of that script. The script sets the progress value of
theprogressed record to 0, so that other processes not to access that row. I presume I would need some locking
solution,only I haven’t found the real one. </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I hope somebody has a bright idea.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Levi</span></font></div>

pgsql-sql by date:

Previous
From: "q2005"
Date:
Subject: the best way to get the first record from each group
Next
From: Antony Paul
Date:
Subject: Maximum length of a query