sql question - Mailing list pgsql-interfaces

From Joseph Shraibman
Subject sql question
Date
Msg-id 384DBF0D.DF9C29AB@selectacast.net
Whole thread Raw
In response to RE: [INTERFACES] JDBC - speed with big 'select's  (Peter Mount <petermount@it.maidstone.gov.uk>)
Responses Re: [INTERFACES] sql question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [INTERFACES] sql question  (Michael Meskes <meskes@postgreSQL.org>)
List pgsql-interfaces
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') ;



pgsql-interfaces by date:

Previous
From: "Brian Haney"
Date:
Subject: VBA Recordset.AddNew and NOT NULL fields
Next
From: Douglas Thomson
Date:
Subject: Re: [INTERFACES] locking on database updates