From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | selects possible in VALUES() claueses? |
Date: | 2003-03-03 03:05:15 |
Message-ID: | 3E62C66B.511B0848@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | bob parker | 2003-03-03 03:19:06 | Re: [GENERAL] Was 26 votes - now still need 10 |
Previous Message | bob parker | 2003-03-03 02:29:28 | Re: [GENERAL] Ok, we just need 26 more votes to win this award.... |