Skip site navigation (1) Skip section navigation (2)

Re: problem porting MySQL SQL to Postgres

From: Reinoud van Leeuwen <reinoud(dot)v(at)n(dot)leeuwen(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: problem porting MySQL SQL to Postgres
Date: 2004-04-15 09:55:56
Message-ID: 20040415095556.GA709@spoetnik.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, Apr 15, 2004 at 11:25:59AM +0100, 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

please use 'IS NULL' instead of '= NULL'

> 	(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.

can you post the output of '\d lu_dewey'?

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud(dot)v(at)n(dot)leeuwen(dot)net
http://www.xs4all.nl/~reinoud
__________________________________________________

In response to

pgsql-sql by date

Next:From: Dan FieldDate: 2004-04-15 10:25:59
Subject: problem porting MySQL SQL to Postgres
Previous:From: Richard HuxtonDate: 2004-04-15 09:12:24
Subject: Re: SQL script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group