Re: COPY FROM WHEN condition - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: COPY FROM WHEN condition
Date
Msg-id 3b2b1aac-5861-acd8-fda3-054c4e4da888@2ndquadrant.com
Whole thread Raw
In response to Re: COPY FROM WHEN condition  (Surafel Temesgen <surafel3000@gmail.com>)
Responses Re: COPY FROM WHEN condition  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers

On 12/12/18 7:05 AM, Surafel Temesgen wrote:
>
>
> On Tue, Dec 4, 2018 at 12:44 PM Alvaro Herrera <alvherre@2ndquadrant.com
> <mailto:alvherre@2ndquadrant.com>> wrote:
>
>     After reading this thread, I think I like WHERE better than FILTER.
>     Tally:
>
>     WHERE: Adam Berlin, Lim Myungkyu, Dean Rasheed, yours truly
>     FILTER: Tomas Vondra, Surafel Temesgen
>
>
>
> accepting tally result  i change the keyword to WHERE condition and
> allow volatile function with single insertion method

Can you also update the docs to mention that the functions called from
the WHERE clause does not see effects of the COPY itself?

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Reorganize collation lookup time and place
Next
From: Tom Lane
Date:
Subject: Bogus EPQ plan construction in postgres_fdw