ERROR: invalid input syntax for integer: "" LINE 1: ...ode WHERE lac_type = '1' AND lan_prefecturecode = '' ORDER B... ^|SOURCE -> SELECT * FROM landmark JOIN landmarkcategory ON lac_code = lan_categorycode WHERE lac_type = '1' AND lan_prefecturecode = '' ORDER BY lan_code ASC;