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
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
>
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
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
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)
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.
