From: | Dan Field <dof(at)llgc(dot)org(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | problem porting MySQL SQL to Postgres |
Date: | 2004-04-15 10:25:59 |
Message-ID: | 4A063822-8EC7-11D8-9677-000A958E367A@llgc.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
Any help would be much appreciated
TIA
--
Dan Field
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2004-04-15 11:15:23 | Re: problem porting MySQL SQL to Postgres |
Previous Message | Reinoud van Leeuwen | 2004-04-15 09:55:56 | Re: problem porting MySQL SQL to Postgres |