Re: COPY IN as SELECT target

2009/12/17 Andrew Dunstan <andrew@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 ....)

Regards
Pavel

>
> 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
>