Re: [HACKERS] UserLock oddity with Limit

2001-05-08 Thread Tom Lane
"Rod Taylor" <[EMAIL PROTECTED]> writes: > Fiddling with userlock stuff for the purposes of setting up an action > queue. Having the lock in the where clause causes the lock code to > actually lock 2 rows, not just the one that is being returned. A WHERE clause should *never* contain function ca

Re: [HACKERS] UserLock oddity with Limit

2001-05-08 Thread Rod Taylor
tertainment Inc. - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Hackers List" <[EMAIL PROTECTED]> Sent: Tuesday, May 08, 2001 11:35 AM Subject: Re: [HACKERS] UserLock oddity with Limit > "Rod T

[HACKERS] UserLock oddity with Limit

2001-05-08 Thread Rod Taylor
Fiddling with userlock stuff for the purposes of setting up an action queue. Having the lock in the where clause causes the lock code to actually lock 2 rows, not just the one that is being returned. 0's in the last section means it could not be locked. This is with 7.1.1. The function itself i