Pavel Stehule wrote:
2009/12/17 Andrew Dunstan <and...@dunslane.net>:
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?
In this case copy doesn't return array - so RETURNING ARRAY is little
bit strange.
what
SELECT .. FROM (COPY VALUES [(colums)] FROM ....)
You are misunderstanding what I want to provide, which is that it *does*
return an array of text for each line. That was what the previous
discussion arrived at, and is illustrated in the example I showed above.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
