Horton

Re: pgsql-server/ oc/src/sgml/ref/alter_table.sgml ...

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Tom Lane <tgl@svr1.postgresql.org>
Cc: pgsql-committers@postgresql.org
Date: 2004-05-05T05:27:09Z
Lists: pgsql-hackers 
> 	* ALTER COLUMN TYPE.  You can change a column's datatype to anything you
> 	want, so long as you can specify how to convert the old value.  Rewrites
> 	the table.  (Possible future improvement: optimize no-op conversions such
> 	as varchar(N) to varchar(N+1).)

That seriously makes me a happy little camper!  Tell the world!

Chris