Received: from odysseus2.dohle.com (root@odysseus2.dohle.com [194.127.185.20]) by hub.org (8.10.1/8.10.1) with ESMTP id e6QBvIA50259 for ; Wed, 26 Jul 2000 07:57:18 -0400 (EDT) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus2.dohle.com (8.9.3/8.9.3) with SMTP id NAA21194; Wed, 26 Jul 2000 13:57:02 +0200 Received: from wpaul.dohle.com by majestix.dohle.com id aa13584; 26 Jul 100 13:57 CETDST Message-ID: <397ED30D.6FF6DA89@dohle.com> Date: Wed, 26 Jul 2000 14:01:18 +0200 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: Bernie Huang CC: PGSQL-SQL Subject: Re: Change attribute of a column References: <397E23FB.CE2E1F85@ec.gc.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/244 Hello, I asked a similar question before and it seems there is no way but using pg_dump. Question to the developers: Is it planned to make type changing (and casting) possible with ALTER TABLE or the like? Volker Bernie Huang wrote: > > Hi, > > I have a field in text[] and I want to change it to a datetime[]. Is it > possible? how? Thanks very much. > > - Bernie > > ------------------------------------------------------------------------ > > Bernie Huang > Programmer > Environment Canada > Standards and Technology Services > > Bernie Huang > Programmer > Environment Canada HTML Mail > Standards and Technology Services > 700-1200 West 73 Ave. Fax: (604)664-9195 > Vancouver Work: (604)664-9172 > BC Netscape Conference Address > V6P 6H9 Netscape Conference DLS Server > Canada > Additional Information: > Last Name Huang > First Name Bernie > Version 2.1