| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Marc Polatschek <Marc(dot)Polatschek(at)computec(dot)de> |
| Cc: | "postgreSQL [GENERAL] (E-Mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with Subquery |
| Date: | 2002-03-07 19:44:05 |
| Message-ID: | 20020307114255.I78057-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-03-07 19:57:04 | Re: Problem with Subquery |
| Previous Message | Joel Burton | 2002-03-07 19:29:53 | Re: Problem with Subquery |