Something went wrong: ERROR: operator does not exist: text > bigint LINE 1: ...= 'post' AND TO_CHAR(post_dt,'YYYYMMDDHH24MISS') > 20070814... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.