Received: from f1node03.rhrz.uni-bonn.de (node03.rhrz.uni-bonn.de [131.220.18.133]) by hub.org (8.10.1/8.10.1) with ESMTP id e62CvmS35935 for ; Sun, 2 Jul 2000 08:57:48 -0400 (EDT) Received: from wabe.in-bonn.de (ascend-tk-p201.dialin.uni-bonn.de [131.220.244.201]) by f1node03.rhrz.uni-bonn.de (8.9.3/8.9.3) with ESMTP id OAA49114 for ; Sun, 2 Jul 2000 14:56:00 +0200 Received: from joachim by wabe.in-bonn.de with local (Exim 3.12 #1 (Debian)) id 138irp-00047z-00 for ; Sun, 02 Jul 2000 14:28:57 +0200 To: pgsql-sql@postgresql.org Subject: Re: retrieving a serial number References: <00062816190002.00209@comptechnews> Mime-Version: 1.0 (generated by tm-edit 1.5) Content-Type: text/plain; charset=US-ASCII From: Joachim Trinkwitz Date: 02 Jul 2000 14:28:57 +0200 In-Reply-To: "Robert B. Easter"'s message of "Wed, 28 Jun 2000 16:12:38 -0400" Message-ID: <87puowzpfa.fsf@wabe.in-bonn.de> Lines: 12 X-Mailer: Gnus v5.6.45/XEmacs 21.1 - "Capitol Reef" X-Archive-Number: 200007/3 "Robert B. Easter" writes: > You can do something like this: > $var = SELECT nextval('seq_name'); > INSERT INTO master (id, ...) VALUES ($var, ...); > INSERT INTO slave1 (id, ...) VALUES ($var, ...); Great feaure. What to do when importing some previous data from ascii files -- can you automatically give a serial number in this way to? Thanks in advance, joachim