Boombatower's conversion doesn't seem to handle HAVING:

  SELECT uid FROM {userpoints} WHERE uid > 0  GROUP BY uid HAVING SUM(points) > %d

I wonder if this even works on a Postgres system, but that's not my issue.

How would this convert to DBTNG? Yes, I know I can still do a db_query (as I am currently doing), but I'd like to convert everything.

Nancy

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.