alter table modify column ...

From: Evelio Martínez <evelio(dot)martinez(at)testanet(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: alter table modify column ...
Date: 2001-11-07 13:08:44
Message-ID: 006d01c1678d$550dc520$4ecd72c3@testanet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi!

I would like to know if there is anything similar to Informix-sql sintax to modify a column type.

I want to change a column from varchar(40) to varchar(40)[].

Do I have to make a stored procedure?
Is there any way to cast a varchar to a _varchar.

Something similar to:

create table kk4 as select numero, idproy, foto, '\'{"' || nombre::_varchar || '"}\'' as nombre, descrip from proy_foto;
ERROR: Cannot cast type 'varchar' to '_varchar'

Any idea will be appreciated.

Thanks in advance
------------
Evelio Martínez

Browse pgsql-general by date

  From Date Subject
Next Message Gordan Bobic 2001-11-07 13:16:57 Performance Question Followup No.2
Previous Message Gordan Bobic 2001-11-07 13:02:28 Performance Question Followup