Re: [GENERAL] LIKE problem

2009-07-05 Thread A. Kretschmer
In response to Juan Pablo Cook : > 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 ~~

Re: [GENERAL] LIKE problem

2009-07-05 Thread Pavel Stehule
2009/7/6 Juan Pablo Cook : > 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 SEL

[GENERAL] LIKE problem

2009-07-05 Thread Juan Pablo Cook
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%';