Re: [aur-dev] [PATCH] Notify users when a package is updated.

Le 27/07/2012 23:24, Mario Mueller a écrit :

Just to get a better understanding... why do you need to select the whole fieldset from CommentNotify if you do not use a single value of it?

SELECT u.Email FROM Users u INNER JOIN CommentNotify cn ON u.ID=cn.UserID AND cn.UserID != $uid AND cn.PkgID = $packageID

does the same from my point of view and returns only one field or do I miss something?

In fact, I don't try to "optimize" this request, I only copy the one in ./web/lib/pkgfuncs.inc.php in the add_package_comment function.