COPY IN as SELECT target

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема COPY IN as SELECT target
Дата
Msg-id 4B2A64AE.50405@dunslane.net
обсуждение исходный текст
Ответы Re: COPY IN as SELECT target  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: COPY IN as SELECT target  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Recently there was discussion about allowing a COPY statement to be a 
SELECT target, returning a text array, although the syntax wasn't really 
nailed down that I recall. I was thinking that  we might have
   COPY RETURNING ARRAY FROM ...

instead of
   COPY tablename opt_column_list FROM ...


the we possibly could do things like:
   SELECT t[5] as a, 3*(t[3]::numeric) as b FROM (COPY RETURNING ARRAY 
FROM STDIN CSV) as t;

Thoughts?

cheers

andrew



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: determine snapshot after obtaining locks for first statement
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: determine snapshot after obtaining locks for first statement