Narrowing using create table select

If I have a table with a c24 field that I would like to remake as a
c20,
in some other db's I would use padr(field,20) which seems to not be
available in Ingres. My next thought was to use cast like:

create table narrowed as
select cast(field as char(20)) as field
from original

but the result is still a c24 field.

If anyone knows how to do this in Ingres, I would be quite grateful!

Thanks,
John

Hi John

alter table alter column

But that depends upon what version of Ingres you are running.

If there are any views that hang off the table you'll need to redefine
them.

Martin Bowes

-----Original Message-----
From: info-ingres-bounces RemoveThis @kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of
NicknameIsNotAvailableInThisGroup
Sent: 13 November 2008 14:26
To: info-ingres RemoveThis @kettleriverconsulting.com
Subject: [Info-Ingres] Narrowing using create table select

If I have a table with a c24 field that I would like to remake as a
c20,
in some other db's I would use padr(field,20) which seems to not be
available in Ingres. My next thought was to use cast like:

create table narrowed as
select cast(field as char(20)) as field
from original

but the result is still a c24 field.

If anyone knows how to do this in Ingres, I would be quite grateful!

Thanks,
John
_______________________________________________
Info-Ingres mailing list
Info-Ingres RemoveThis @kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres