From: | Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net> |
---|---|
To: | Michael Meskes <meskes(at)postgreSQL(dot)org> |
Cc: | Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>, pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] sql question |
Date: | 1999-12-08 19:36:25 |
Message-ID: | 384EB339.62C5E2B3@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Assaf Arkin | 1999-12-08 19:41:02 | Re: [INTERFACES] Transaction support in 6.5.3/JDBC |
Previous Message | stuart | 1999-12-08 15:57:28 |