From: Stephen Jackson <Stephen.Jackson@panting-deer.org.uk>
To: pgsql-sql@postgresql.org
Subject: Implicit/Explicit casting of the unknown type
Date: Mon, 26 Mar 2001 21:03:55 +0100
Message-ID: <3ABFA0AB.51025C8E@panting-deer.org.uk> (raw)
Hi,
I am new to this list. I have browsed the list archives and tried a
search, but haven't found anything about my problem.
I am porting several applications to PostgreSQL and have come across a
number of instances where a string literal does not work without an
explicit cast to some character based datatype. Two examples are given
below: one where the string literal is in the column list, and one where
it is in a WHERE clause.
Are there bugs in the area of determining a type for the unknown type?
Or is explicit casting of string literals to a known type generally
required by PostgreSQL?
TIA,
Stephen Jackson
Home: Stephen.Jackson@panting-deer.org.uk www.panting-deer.org.uk
Work: Stephen.Jackson@looksystems.co.uk www.looksystems.co.uk
[begin examples]
version
---------------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
DROP TABLE strange
DROP
CREATE TABLE strange ( record_id integer )
CREATE
INSERT INTO strange ( record_id ) VALUES ( 10 )
INSERT 5174249 1
SELECT DISTINCT record_id, 123
FROM strange WHERE record_id < 100
record_id | ?column?
-----------+----------
10 | 123
(1 row)
SELECT DISTINCT record_id, 'Hello'
FROM strange WHERE record_id < 100
ERROR: Unable to identify an ordering operator '<' for type 'unknown'
Use an explicit ordering operator or modify the query
SELECT record_id, 'Hello'
FROM strange WHERE record_id < 100
record_id | ?column?
-----------+----------
10 | Hello
(1 row)
SELECT COUNT(*) FROM strange
WHERE 'TR' || 'UE' = 'TRUE'
count
-------
1
(1 row)
SELECT COUNT(*) FROM strange
WHERE 'TRUE' = 'TRUE'
ERROR: Unable to identify an operator '=' for types 'unknown' and
'unknown'
You will have to retype this query using an explicit cast
[end examples]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Stephen.Jackson@panting-deer.org.uk
Subject: Re: Implicit/Explicit casting of the unknown type
In-Reply-To: <3ABFA0AB.51025C8E@panting-deer.org.uk>
References: <3ABFA0AB.51025C8E@panting-deer.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox