LIKE problem

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

Responses

Browse pgsql-general by date

  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.