Column names for INSERT with query

Поиск
Список
Период
Сортировка
От Robert James
Тема Column names for INSERT with query
Дата
Msg-id CAGYyBggz6AK0JBZdY+SwO7k0bsbM0ouL8HPqRHc9GV_NgRyuPA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Column names for INSERT with query
Re: Column names for INSERT with query
Re: Column names for INSERT with query
Список pgsql-general
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?


В списке pgsql-general по дате отправления: