''Search data in tables' works very well in Mysql but in postgres there an error
There is an error for field date because they doesn't support % joker char.
ERROR: operator does not exist: timestamp without time zone ~~ unknown
LINE 1: ... "process_transition_action" WHERE ("create_date" LIKE '%mod...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
A second error :
ERROR: argument of WHERE must be type boolean, not type integer
LINE 1: ...FROM "account_account_financial_report_type" WHERE 0 LIMIT 1
I think than string search shoudn't search in boolean, date type field
Log in to post a comment.