JORGE MALDONADO, 07.06.2013 15:58: > I need to insert records into a table where one value is fixed and 2 values > come from a SELECT query, something like the following example: > > INSERT INTO table1 fld1, fld2, fl3 > VALUES value1, (SELECT fldx, fldy FROM table2) > > Is this valid? > > Respectfully, > Jorge Maldonado
INSERT INTO table1 (fld1, fld2, fl3) SELECT value1, fldx, fldy FROM table2 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql