On Sun, May 31, 2009 at 9:54 PM, Jamie Tufnell wrote:
> BEGIN;
> SELECT * FROM records
> WHERE in_edit_queue AND id NOT IN (
> SELECT record_id FROM locked_records
> WHERE locked_since < now() + interval '5 minutes')
> LIMIT 1;
>
> INSERT INTO locked_records (record_id, locked_since) VALUES (?
tOn 2009-06-01, Jamie Tufnell wrote:
> --00163646d8e6795c49046b4163e0
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I am trying to provide a simple data entry interface to allow multiple
> people to efficiently work through every record in a table and
OT: Sorry for top-posting I've been using a ticket interface all morning.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Hi,
I am trying to provide a simple data entry interface to allow multiple
people to efficiently work through every record in a table and fill in the
missing values.
The interface is a web application that simply loads up record after record
until they're all complete.
I want to minimize the pos
Just want to correct a small but significant error in the first query:
WHERE locked_since < now() + interval '5 minutes'
Should read:
WHERE locked_since BETWEEN now() - interval '5 minutes' AND now();
On 6/1/09, Jamie Tufnell wrote:
> Hi,
>
> I am trying to provide a simple data entry interfac
