Re: [INTERFACES] sql question
| От | Joseph Shraibman |
|---|---|
| Тема | Re: [INTERFACES] sql question |
| Дата | |
| Msg-id | 384EB339.62C5E2B3@selectacast.net обсуждение исходный текст |
| Ответ на | RE: [INTERFACES] JDBC - speed with big 'select's (Peter Mount <petermount@it.maidstone.gov.uk>) |
| Список | pgsql-interfaces |
Michael Meskes wrote: > 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'; > owl=> INSERT INTO application (key, creator, name) values (select 1,userkey, 'newapplication' from user where username = 'b' ) ; ERROR: parser: parse error at or near "select" owl=> INSERT INTO application (key, creator, name) SELECT 1, userkey, owl-> 'newapplication' from user where username = 'b'; ERROR: parser: parse error at or near "user" owl=> Any other ideas?
В списке pgsql-interfaces по дате отправления: