On Mon, Jun 28, 2021 at 8:40 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Jun 28, 2021 at 8:34 AM PG Doc comments form <
> nore...@postgresql.org> wrote:
>
>> For example:
>> UPDATE table1 SET status='expired' WHERE id in (SELECT wrong_id IN table2)
>>
>> This will update ev
On Mon, Jun 28, 2021 at 8:34 AM PG Doc comments form
wrote:
> For example:
> UPDATE table1 SET status='expired' WHERE id in (SELECT wrong_id IN table2)
>
> This will update every row in table1if wrong_id doesn't exist, ignoring the
> ERROR: column "wrong_id" does not exist from the subquery.
>
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-subquery.html
Description:
I have found that when a sub query fails, the preceeding IN will ignore the
failure and execute as if the subquery did not exist.
I think this should
