Re: Document behaviour of failed sub queries

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

Re: Document behaviour of failed sub queries

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