From: | Juan Pablo Cook <juampick(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | LIKE problem |
Date: | 2009-07-06 05:55:54 |
Message-ID: | 90019f490907052255v26916ac7x4df5781890a0132e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Everybody! I'm asking you, because recently I have some problems with the
LIKE so I test with an easy and simple query but doesn't work:
SELECT *
FROM employee
WHERE id like 'h%';
The error says:
"ERROR: operator does not exist: integer ~~ unknown
LINE 5: WHERE id like 'h%';
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
********** Error **********
ERROR: operator does not exist: integer ~~ unknown
SQL state: 42883
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Character: 34"
I don't know why because I did before more difficult querys and works well.
What is the problem?
Thanks a lot
JP Cook
From | Date | Subject | |
---|---|---|---|
Next Message | CM J | 2009-07-06 05:58:51 | Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index |
Previous Message | Mohan Raj B | 2009-07-06 05:37:25 | COALESCE not filtering well. |