selects possible in VALUES() claueses? - Mailing list 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