Skip site navigation (1) Skip section navigation (2)

Alter column

From: Thiemo Kellner <thiemo(at)gmx(dot)ch>
To: pgNovice <pgsql-novice(at)postgresql(dot)org>,pgSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Alter column
Date: 2002-07-27 01:46:30
Message-ID: 3D41FB76.8080509@gmx.ch (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
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


pgsql-novice by date

Next:From: Ludwig LimDate: 2002-07-27 02:26:15
Subject: some questions
Previous:From: Jim SteilDate: 2002-07-26 19:49:30
Subject: Auto-incrementing field

pgsql-sql by date

Next:From: Dan LangilleDate: 2002-07-27 21:26:02
Subject: using LIMIT only on primary table
Previous:From: Roberto MelloDate: 2002-07-26 21:53:48
Subject: Re: RES: [GENERAL] set DateStyle to 'SQL'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group