Received: from bering.webline.dk (83.adsl0.kh.worldonline.dk [213.237.10.83]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0DBaTp46054 for ; Sat, 13 Jan 2001 06:36:29 -0500 (EST) (envelope-from kar@webline.dk) Received: from localhost (localhost [[UNIX: localhost]]) by bering.webline.dk (8.10.2/8.10.2/SuSE Linux 8.10.0-0.3) id f0DBbYb24344 for pgsql-sql@postgresql.org; Sat, 13 Jan 2001 12:37:34 +0100 From: Kaare Rasmussen Date: Sat, 13 Jan 2001 12:37:34 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgresql.org References: <7j3denn367.fsf@junk.nocrew.org> In-Reply-To: <7j3denn367.fsf@junk.nocrew.org> Subject: Re: new serial type MIME-Version: 1.0 Message-Id: <01011312373400.24341@bering> Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/124 X-Sequence-Number: 785 Den lørdag 13. januar 2001 11:42 skrev Rolf Johansson: > Is there some function to change the serial type to, instead of reading > a next-value, read the maxium value in a column and then add x? If, for You can use setval(sequence, number) and MAX(number) in combination. -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Email: kar@webline.dk 2000 Frederiksberg Lørdag 11.00-17.00 Web: www.suse.dk