On Tue, 25 Mar 2003, Chad Thompson wrote:
> The assumtion that char and varchar can be compared is gone. Any comparison
> or in this case concatination between the two types needs to be explicitly
> cast.
>
> try
> SELECT code::varchar || ' ' || diag::varchar, code
> FROM dsm4
> WHERE axis = 1
>
al Message -
From: "Thomas Good" <[EMAIL PROTECTED]>
To: "Postgres SQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 3:28 PM
Subject: [SQL] Concatenation Snafu
SELECT code || ' ' || diag, code
FROM dsm4
WHERE axis = 1
ORDER BY code;
This worked o
SELECT code || ' ' || diag, code
FROM dsm4
WHERE axis = 1
ORDER BY code;
This worked on 6.3-7.3.1 now it dies with:
'unable to identify an operator || for types 'character' and 'character
varying'
What happened?
---
Thomas
