Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

like operator doesnt seem to work. #19

Open
haggerty-william opened this issue Feb 24, 2017 · 2 comments
Open

like operator doesnt seem to work. #19

haggerty-william opened this issue Feb 24, 2017 · 2 comments

Comments

@haggerty-william
Copy link

I don't know if this is an issue or just user error.
I have been trying to get the following query to execute: select message from logs where message like $1

This is the table schema: CREATE TABLE logs (id BIGSERIAL PRIMARY KEY, logTime timestamp, ip text, machine text, agent text, name text, level text, code SMALLINT, message text);

The query parameter is "%Ack complete%".
The error message is: table "like" does not exist

@haggerty-william haggerty-william changed the title 'Where like' doesnt seem to work. like operator doesnt seem to work. Feb 24, 2017
@haggerty-william
Copy link
Author

FYI:
The finalQuery variable before being written to the db connection in stmt.go Query() is:
select message from logs where message like $$%Ack complete%$$

@haggerty-william
Copy link
Author

I looked through some code and it doesn't look like the 'like' operator is implemented. Ill try to set aside some time and take a crack at implementing it when I get a chance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant