Quote Originally Posted by DaPi
and partition_name like 'x_part_name%'
should be
and partition_name like x_part_name||'%'
Your powers are weak, old man.