Received: from nyffeltrach.thiam.ch (zux172-196.adsl.green.ch
 [80.254.172.196])
	by postgresql.org (Postfix) with ESMTP
	id BD4B1475AE4; Fri, 26 Jul 2002 21:46:39 -0400 (EDT)
Received: from gmx.ch (walhalla.thiam.ch [192.168.0.249])
	by nyffeltrach.thiam.ch (Postfix on SuSE Linux 7.2 (i386)) with ESMTP
	id 8CF88C2F3; Sat, 27 Jul 2002 03:46:31 +0200 (CEST)
Message-ID: <3D41FB76.8080509@gmx.ch>
Date: Sat, 27 Jul 2002 03:46:30 +0200
From: Thiemo Kellner <thiemo@gmx.ch>
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US;
	rv:1.0.0) Gecko/20020529
X-Accept-Language: de-ch, en, es-es, en-us
MIME-Version: 1.0
To: pgNovice <pgsql-novice@postgresql.org>,
	pgSQL <pgsql-sql@postgresql.org>
Subject: Alter column
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200207/234
X-Sequence-Number: 4403

Hi,

I wonder if I can alter the type of a column to a "supertype" of the 
original column type? Afaik, this was impossible in 7.1.3. However, I 
use 7.2.1. If yes, what would be the correct syntax?

Cheers,

Thiemo

-- 
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur
http://jermt.sourceforge.net