Re: Problem with Subquery

On Thu, 7 Mar 2002, Marc Polatschek wrote:

> We recently changed our database system from Oracle 8i to postgreSQL. Im
> right now changing our cold fusion code and i have get this problem:
>
>     select    ID,
>             NAME,
>             WEBSITE_URL,
>             (
>             select    count(*)
>             from        MAIN_PC_GAME,
>                     MAIN_COMPANY
>             where        DEVELOPER_ID = MAIN_COMPANY.ID
>             or        PUBLISHER_ID = MAIN_COMPANY.ID
>             ) as TOTAL
>     from        MAIN_COMPANY
>     where        (
>                      lower(SOFTWARE_DEVELOPER)='yes'
>             or         lower(SOFTWARE_PUBLISHER)='yes'
>             )
>
> This SQL statement isnt working with postgreSQL but it worked without
> any problems in Oracle. Postgres Error Message:
>
>     Unable to identify an operator '=' for types 'character varying'
> and 'numeric'
>     You will have to retype this query using an explicit cast

It'd help if you sent the schema for the tables involved.  Are the ids
of differing types?