On Wed, May 11, 2011 at 09:55:39AM +0200, Henning Grosch wrote:

Is it somehow possible to to add a column with alter table behind an specific column? Example: ALTER TABLE xxx ADD COLUMN newCol int AFTER oldCol; No this isn't possible. We only support the aad column part not the 'after' part. What would be the advantage of specifing this ?

Niels

Henning

------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl