selects possible in VALUES() claueses?
От | Dennis Gearon |
---|---|
Тема | selects possible in VALUES() claueses? |
Дата | |
Msg-id | 3E62C66B.511B0848@cvc.net обсуждение исходный текст |
Ответы |
Re: selects possible in VALUES() claueses?
Re: selects possible in VALUES() claueses? |
Список | pgsql-general |
Is it possible to do this? INSERT INTO Usrs( first_name, middle_name, sur_name, sur_name_extra, gen_id, login ) VALUES ( 'Dennis'::text, 'Keith'::text, 'Gearon'::text, 'none'::text, (SELECT gen_id FROM Gens WHERE gen = 'none'::varchar), 'dude'::varchar ); It's puking with the following error: Error - /phpPgAdmin/path/and/file -- Line: 112 PostgreSQL said: ERROR: parser: parse error at or near "SELECT" Your query: INSERT INTO Usrs( first_name, middle_name, sur_name, sur_name_extra, gen_id, login ) VALUES ( 'Dennis'::text, 'Keith'::text, 'Gearon'::text, 'none'::text, (SELECT gen_id FROM Gens WHERE gen = 'none'::varchar), 'dude'::varchar ) -- Carpe Dancem ;-) ----------------------------------------------------------------- Remember your friends while they are alive ----------------------------------------------------------------- Sincerely, Dennis Gearon
В списке pgsql-general по дате отправления: