Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA01980 for ; Tue, 7 Dec 1999 23:05:24 -0500 (EST) (envelope-from jks@p1.selectacast.net) Received: from p1.selectacast.net (root@p1.selectacast.net [206.41.1.251]) by trends.net (8.8.8/8.8.8) with ESMTP id VAA05023 for ; Tue, 7 Dec 1999 21:17:57 -0500 (EST) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id VAA11891 for ; Tue, 7 Dec 1999 21:14:42 -0500 Sender: jks@p1.selectacast.net Message-ID: <384DBF0D.DF9C29AB@selectacast.net> Date: Tue, 07 Dec 1999 21:14:37 -0500 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: sql question References: <1B3D5E532D18D311861A00600865478C70BF00@exchange1.nt.maidstone.gov.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there any way to get something like this into valid sql? Postgres doesn't like this: INSERT INTO application (key, creator, name) values ( 1 ,(select userkey from user where username = 'b' ), 'newapplication') ;