"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
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
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