From: CoL <col@mportal.hu>
Subject: Re: problem porting MySQL SQL to Postgres
Date: Thu, 15 Apr 2004 13:30:12 +0200
Organization: Hub.Org Networking Services
Lines: 36
Message-ID: <c5lro4$2mip$1@news.hub.org>
References: <4A063822-8EC7-11D8-9677-000A958E367A@llgc.org.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla Thunderbird 0.5+ (Windows/20040223)
In-Reply-To: <4A063822-8EC7-11D8-9677-000A958E367A@llgc.org.uk>
To: pgsql-sql@postgresql.org

hi,

Dan Field wrote:

> I've stumbled across a query I don't quite understand the error message 
> for.
> 
> This query is pulled from a working MySQL setup:
> 
> SELECT
>     DEWEY_ID, DEWEY_HUNDREDS, DEWEY_TENS, DEWEY_ONES,     
> DEWEY_POINT_ONES, DEWEY_POINT_TENS,    
>     DEWEY_POINT_HUNDREDS, DEWEY_POINT_THOUSANDS,      DEWEY_TYPE, 
> DEWEY_LANG,  DEWEY_SUBJECT  FROM lu_dewey
> WHERE
>     (DEWEY_HUNDREDS = 9) AND
>     (DEWEY_TENS >= 0) AND    
>     (DEWEY_TENS <= 9) AND
>     (DEWEY_ONES = 0 || DEWEY_ONES = NULL) AND
>     (DEWEY_POINT_ONES = 0 || DEWEY_POINT_ONES = NULL) AND
>     (DEWEY_POINT_TENS = 0 || DEWEY_POINT_TENS = NULL) AND
>     (DEWEY_POINT_HUNDREDS = 0 || DEWEY_POINT_HUNDREDS = NULL) AND
>     (DEWEY_POINT_THOUSANDS = 0 || DEWEY_POINT_THOUSANDS = NULL) AND
>     (DEWEY_TYPE = 't') AND
>     (DEWEY_LANG = 'en')
> ORDER BY DEWEY_TENS
> 
> 
> However I'm getting the following error:
> 
>  ERROR:  Unable to identify an operator '=' for types 'character' and 
> 'boolean' You will have to retype this query using an explicit cast.

use OR not ||.

C.