cannot save query with LIKE operator

[azimut]

Description

I want to save a simple query that uses a LIKE operator. I can save it. But at call it returns "Bad arguments". I assume is trying to interpret the % on the query as parameters. But that is not what I want.

user@192.168.1.3:mydb> \ns a SELECT * from events WHERE description LIKE '%http%';
Time: 0.003s
user@192.168.1.3:mydb> \n a
Bad arguments

Your environment

• Installed through pip
• Python 2.7
• Gentoo
• pgcli==1.9.0

[judalabs]

Try this:

\ns a SELECT * from events WHERE description LIKE CONCAT('%%', 'http', '%%');

NOTE: The double percent is used to escaping

[amjith]

This issue has been fixed a while back. Can you try upgrading pgcli?

pip install -U pgcli