2013/8/23 Robert James <srobertja...@gmail.com>:
> I would like to:
>
> INSERT INTO t
> SELECT * FROM r, (x + y) AS field3
>
> How do I correlate the names of the fields? That is, how do I indicate
> which fields from r or field3 should be inserted into the right
> columns in t?
INSERT INTO t (t_field1, t_field2, t_field3)
SELECT r.field1, r.field2, (x+y)
FROM r
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
