Re: [SQL] Assigning data-entry tasks to multiple concurrent clients

2009-05-31 Thread Jamie Tufnell
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

[SQL] Assigning data-entry tasks to multiple concurrent clients

2009-05-31 Thread Jamie Tufnell
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

Re: [SQL] Assigning data-entry tasks to multiple concurrent clients

2009-05-31 Thread Jamie Tufnell
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