[adminer-tracker] [ adminer-Bugs and Features-3614178 ] field date postgres in 'Search data in tables' form

[SourceForge.net <no...@so...>]

Bugs and Features item #3614178, was opened at 2013-05-31 01:12
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3614178&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: PostgreSQL
Group: 3.7.0
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Jakub Vrána (jakubvrana)
Summary: field date postgres in 'Search data in tables' form

Initial Comment:
''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


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3614178&group_id=264133