Hello,
Atul here, i have one table and i would like to increase the length of
existing column and the sql statement is
Exisiting Column is "vehicle_make" varchar(30)
SQL: alter table commute_profile alter column "vehicle_make"
varchar(100)
But this gives error.
http://fts.postgresql.org/db/mw/msg.html?mid=1071582
On Tue, 2003-03-25 at 10:18, Christoph Haller wrote:
> >
> > Atul here, i have one table and i would like to increase the length
> of
> > existing column and the sql statement is
> >
> >Exisiting Column is "vehicle_make" varchar(30)
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
On Tue, Mar 25, 2003 at 20:24:55 +0100,
Tomasz Myrta <[EMAIL PROTECTED]> wrote:
> Uz.ytkownik Josh Berkus napisa?:
>
> It looks it could be useful to display how much time is left for
> scheduling cases, but as I wrote few threads ago - displaying intervals
> longer than one month is useless wit
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;
Thanks
Chad
- Original Message -
Fro
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
>
