> 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