Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA84306 for ; Tue, 8 Jun 1999 09:18:27 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.8/NETTuno 3.2) with ESMTP id PAA03701; Tue, 8 Jun 1999 15:17:33 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10rNdR-00008Y-00; Tue, 8 Jun 1999 15:17:53 +0000 Message-ID: <375D1768.81F82776@sferacarta.com> Date: Tue, 08 Jun 1999 15:15:20 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Robert Chalmers CC: pgsql-sql@postgresql.org Subject: Re: [SQL] Standard SQL commands - are they in 6.5? References: <003c01beac77$dcf545e0$1a6001cb@chalmers.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Robert Chalmers ha scritto: > The following doesn't work in 6.xxx. Will it work in 6.5???? > > ............................ > A standard SQL command to do this would be > > ALTER TABLE tablename MODIFY existingColumnName CHAR( 24 ); > > This is an useful command, although it isn't an SQL standard command. ______________________________________________________________ PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Jose'