ERROR: syntax error at or near "::" LINE 36: AND est_locationcode IN(::text) ^|SOURCE -> SELECT est_updateprogram, estchain_join.cha_chain FROM pubestatechain28_parent AS estchain_join LEFT JOIN estate_score28 ON esc_estatecode = estchain_join.est_code LEFT JOIN agent_option_it_apamanshop ON agent_option_it_apamanshop.agt_code = est_agentcode LEFT JOIN lifull_it ON lifull_it.est_code = estchain_join.est_code LEFT JOIN estate_extend_visitreserve ON estate_extend_visitreserve.eev_estatenumber = estchain_join.est_number WHERE TRUE AND est_publishingperiod >= 'now'::date AND ( (est_estatetypecode = '3103') OR ( (est_estatetypecode = '3104') OR (est_estatetypecode = '3105') ) ) AND est_locationcode IN(::text) AND ST_Intersects(est_latitudelongitude, '0103000020E61000000100000021000000789BF89F6C6261404F467B484F2F4240CEA0D6396B62614060CFE191152F4240734F9D5F666261403A852DD9DD2E424040F116415E626140C96F8242AA2E424060642D2E53626140D23254C97C2E42405C7BD69345626140AAA0E82C572E4240A86AE3F7356261403F0B2BDF3A2E4240FB93DCF3246261400CBF78F6282E42402D391C2F1362614052CDF122222E42407CEA615801626140FBC0B6A7262E4240E59B1D1FF0616140F55E5558362E42402705B42CE0616140019B7D9A502E42402F2FFE1DD26161400302EE6B742E42406FD6437DC6616140B0955D6CA02E424054A8EBBCBD616140CC0002EBD22E424055841533B861614076A12DF7092F4240320E4A16B6616140787F6273432F4240A858607BB7616140FD091F2A7D2F4240DD9FAE54BC616140DE5A98E3B42F424054628E72C4616140546B8C7BE82F4240381F2F85CF6161400D8255F615304240C719A61FDD61614053406F943B304240B83B1DBCEC616140D3D6ACE3573042402D08F8C0FD616140028376CD6930424072F8BB860F6261405BAB81A17030424059F7815E216261401CA4991C6C3042401750B1983262614065FF356B5C3042409182C18B4262614052C8C427423042408428C09A506261408D87B9541E304240B86F5A3B5C626140C3C79B52F22F4240958C2EFB64626140955B77D2BF2F4240CDBA30846A626140EF5A34C5882F4240789BF89F6C6261404F467B484F2F4240') AND ARRAY[est_estatetypecode] <@ ARRAY[3103,3104,3105]