Received: from ural2.hszk.bme.hu (ural2.hszk.bme.hu [152.66.130.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8HCst883884 for ; Mon, 17 Sep 2001 08:54:55 -0400 (EDT) (envelope-from kb136@hszk.bme.hu) Received: (from kb136@localhost) by ural2.hszk.bme.hu (8.11.3/8.11.3) id f8HCspZ29241; Mon, 17 Sep 2001 14:54:51 +0200 (MEST) Date: Mon, 17 Sep 2001 14:54:51 +0200 (MEST) From: Kovacs Baldvin X-X-Sender: To: Haller Christoph cc: Subject: Re: Number the lines In-Reply-To: <200109171215.OAA21602@rodos> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200109/105 X-Sequence-Number: 4769 Hi! I am in the university now, not be able to test what I say, so please forgive me if it is buggy or wrong. So does it helps you?: CREATE SEQUENCE ordering; SELECT NEXTVAL('ordering') as rownumber, * INTO TABLE anewname FROM whatyouwant; Probably CREATE SEQUENCE 'ordering';, do try it... Bye, Baldvin