dtoi4 error

I'm working on porting an application from MySQL to PostgreSQL. We have one
query which is rather monstrous. When I run this query, I'm getting an
error 'dtoi4: integer out of range'. I'm not sure what's causing it, and
I'm not sure how to fix it. Since Postgres isn't giving me a very detailed
error message, I'm sort of at a loss of where to search to find where the
conversion is failing.

The MySQL functions listed have counterparts written in Postgres (Zachary
Beane's available functions).

Here's the query:

SELECT h.id, h.name, h.info, h.comm, h.gid, h.active,
h.low, h.sys, h.rev,
UNIX_TIMESTAMP( p.next ) AS next, p.id, p.did as dwid,
pt.units, pt.interval, pt.table, pt.name,
pt.type, IFNULL( sl.state, 0 ) AS state, sl.value,
UNIX_TIMESTAMP( sl.start_time ) AS sctstamp,
sl.state AS log_state,
SUM( IFNULL( sd.state, 0 ) >> 1 ) AS dephold,
IFNULL( pth.d1_time, ptt.d1_time ) AS d1_time,
IFNULL( pth.d1_min, ptt.d1_min ) AS d1_min,
IFNULL( pth.d1_max, ptt.d1_max ) AS d1_max,
IFNULL( pth.d2_time, ptt.d2_time ) AS d2_time,
IFNULL( pth.d2_min, ptt.d2_min ) AS d2_min,
IFNULL( pth.d2_max, ptt.d2_max ) AS d2_max,
r.running, plf.field, plf.min, plf.max,
wft.maptype AS field_type
FROM percept p
INNER JOIN h1 h ON h.id=p.id
INNER JOIN pt1 pt ON pt.ptid=p.ptid
LEFT JOIN pth1 pth ON pth.id=p.id
LEFT JOIN sl1 sl ON sl.id=p.id AND sl.dur IS NULL
LEFT JOIN pdc1 pdc ON pdc.id=p.id
LEFT JOIN sl1 sd ON pdc.did=sd.id AND
sd.duration IS NULL
LEFT JOIN run r ON p.id=r.id
LEFT JOIN plf1 plf ON p.id=plf.id
LEFT JOIN ptt1 ptt ON p.ptid=ptt.ptid
LEFT JOIN wft1 wft ON plf.t=wft.fieldtype AND
pt.type=wft.type
WHERE p.deleted = 0 AND
p.next <= NOW() AND
pt.interval IS NOT NULL AND
r.running IS NULL
GROUP BY h.id, h.name, h.info, h.comm, h.gid,
h.active, h.low, h.sys, h.rev,
p.next, p.id, pt.units, pt.interval, pt.table,
pt.name, sl.state, sl.value, sl.start_time,
r.running, plf.field, plf.min, plf.max,
pt.type, p.did, wft.maptype,
IFNULL( pth.d1_time, ptt.d1_time ),
IFNULL( pth.d1_min, ptt.d1_min ),
IFNULL( pth.d1_max, ptt.d1_max ),
IFNULL( pth.d2_time, ptt.d2_time ),
IFNULL( pth.d2_min, ptt.d2_min ),
IFNULL( pth.d2_max, ptt.d2_max )
HAVING SUM( IFNULL( sd.state, 0 ) >> 1 ) = 0

If I change the where to be 'WHERE p.id=5' (or any other member integer),
the query succeeds with no problems. Table names and fields have been
changed, but that shouldn't make a difference.

Any ideas?
Thanks in advance for any assistance,
Philip