Potential Bug in SQL Editor?

SELECT 
    usename,
    application_name,
    client_addr,
    state,
    EXTRACT(EPOCH FROM (now() - state_change))::INTEGER as idle_seconds,
    query as last_query
FROM pg_stat_activity 
WHERE state = 'idle'
ORDER BY state_change DESC;