| From: | Thomas Good <tomg(at)sqlclinic(dot)net> |
|---|---|
| To: | Postgres SQL List <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Concatenation Snafu |
| Date: | 2003-03-25 22:28:08 |
| Message-ID: | Pine.LNX.4.44.0303251726580.23371-100000@q8.nrnet.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 Good e-mail: tomg(at)sqlclinic(dot)net
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 - Fr Frieden und globale Gerechtigkeit!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad Thompson | 2003-03-25 23:01:03 | Re: Concatenation Snafu |
| Previous Message | patrick | 2003-03-25 20:32:03 | Re: Insert race hazard condition. |