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

From Adam Berlin
Subject Re: COPY FROM WHEN condition
Date
Msg-id 154177868369.24563.8425283889569429535.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: COPY FROM WHEN condition  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: COPY FROM WHEN condition  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
As a newcomer to this patch, when I read this example:

COPY table_name WHEN (some_condition)

.. I expect COPY to only be run when the condition is true, and I do not expect the WHEN clause to filter rows. I'm
curiouswhat you think about:
 

COPY table_name WHERE (some_condition)

Users should already be familiar with the idea that WHERE performs a filter.

pgsql-hackers by date:

Previous
From: Nikita Glukhov
Date:
Subject: Re: jsonpath
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15212: Default values in partition tables don't work asexpected and allow NOT NULL violation