Received: from pille.addcom.de (qmailr@h-62.96.128.34.host.de.colt.net [62.96.128.34]) by hub.org (8.9.3/8.9.3) with SMTP id CAA19433 for ; Wed, 8 Dec 1999 02:49:10 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: (qmail 21169 invoked from network); 8 Dec 1999 07:49:06 -0000 Received: from h-62.96.148.197.host.de.colt.net (root@62.96.148.197) by pille.addcom.de with SMTP; 8 Dec 1999 07:49:06 -0000 Received: (from michael@localhost) by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id IAA00713; Wed, 8 Dec 1999 08:45:31 +0100 Date: Wed, 8 Dec 1999 08:45:31 +0100 From: Michael Meskes To: Joseph Shraibman Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] sql question Message-ID: <19991208084531.A704@fam-meskes.de> Mail-Followup-To: Joseph Shraibman , pgsql-interfaces@postgreSQL.org References: <1B3D5E532D18D311861A00600865478C70BF00@exchange1.nt.maidstone.gov.uk> <384DBF0D.DF9C29AB@selectacast.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <384DBF0D.DF9C29AB@selectacast.net>; from jks@p1.selectacast.net on Tue, Dec 07, 1999 at 09:14:37PM -0500 On Tue, Dec 07, 1999 at 09:14:37PM -0500, Joseph Shraibman wrote: > INSERT INTO application (key, creator, name) values ( 1 ,(select userkey > from > user where username = 'b' ), 'newapplication') ; INSERT INTO application (key, creator, name) SELECT 1, userkey, 'newapplication' from user where username = 'b'; Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!