Re: [HACKERS] Ocasional problems !!!!

[Thomas Lockhart]

> i'm having this message:
> ERROR:  Unable to identify an operator '=' for types 'int4' and 'text'
>         You will have to retype this query using an explicit cast

Without knowing your schema and query, we can't tell you exactly. But
your query is trying to compare a string to an integer, which you can do
by using an explicit cast. For example,

  select text '123' = 123;

will fail, but

  select cast((text '123') as integer) = 123;

will succeed.

                    - Thomas