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 > ORDER BY code;
Hi Chad, yes I did a CAST(code AS varchar) and it works...I suppose this is an "improvement" to Pg as it prevents the risk of standardising our concatenation syntax with Oracle. ;-) This sort of thing is irritating when you have to support more than one type of backend! Thanks for the post, Tom ----------------------------------------------------------------------- Thomas Good e-mail: [EMAIL PROTECTED] Programmer/Analyst phone: (+1) 718.818.5528 Residential Services fax: (+1) 718.818.5056 Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359 // Krieg ist selbst Terror - Für Frieden und globale Gerechtigkeit! ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
