Re: [SQL] Implementing queue semantics (novice)

2005-01-13 Thread KÖPFERL Robert
Robert > Cc: '[email protected]' > Subject: Re: [SQL] Implementing queue semantics (novice) > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > The name for what you're looking to build is a concurrent batch > processing system. Here's a ba

Re: [SQL] Implementing queue semantics (novice)

2005-01-12 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The name for what you're looking to build is a concurrent batch processing system. Here's a basic one. - -- adding processes BEGIN; INSERT INTO queue (queue_id, processing_pid, processing_start, ~ processing_status, foreign_id) VALUES (DEFAULT, NULL, NU