Andrew Dunstan wrote: > > 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 ...
It's not really returning an array, is it? It's returning a bag of rows like a (sub)query. > 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; How about just COPY FROM? As in SELECT t[5] as a, 3*(t[3]::numeric) as b FROM (COPY FROM STDIN CSV) as t -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
