>
> INSERT INTO temp SELECT campo_int4 FROM otra_tabla
> WHERE campo_int4 IN (1, 2, 3, 4, 5)
>
> Que funciona perfectamente pero necesito otra tabla y
> la expresión es más complicada.
>
si solo quieres insertar esos 5 valores prueba esto,
insert into temp select generate_series(1, 5);
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook