selects possible in VALUES() claueses?

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

Responses

Browse pgsql-general by date

  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....