Hash partitioning now works as long as the SQL statement is modified

SELECT *
FROM rif40.rif40_study_shares
WHERE rif40_sql_pkg._rif40_hash(1::VARCHAR, 16) = hash_partition_number
/* Elininates */
AND study_id = 1
ORDER BY 1 LIMIT 10;