public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: UPDATE-FROM and INNER-JOIN
Date: Mon, 5 Aug 2024 06:04:48 -0700
Message-ID: <CAKFQuwYcFGgS9itAqsUj5Y02UtDXr8yBtac9w+v+45pLEu4U3Q@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh-_Hm87rHcGNvScJ8AW9wdOekBnCP3yfGMWQdyoQYxHcZw@mail.gmail.com>
References: <CAFCRh-_Hm87rHcGNvScJ8AW9wdOekBnCP3yfGMWQdyoQYxHcZw@mail.gmail.com>

On Monday, August 5, 2024, Dominique Devienne <[email protected]> wrote:

> In https://sqlite.org/forum/forumpost/df23d80682
> Richard Hipp (Mr SQLite) shows an example of something
> that used to be supported by SQLite, but then wasn't, to be
> compatible with PostgreSQL.
>
> Thus I'm curious as to why PostgreSQL refuses the first formulation.
> Could anyone provide any insights? Thanks, --DD
>

Interesting…but not too surprising.  The joining condition between the
update relation and the from relation needs to be done in the where
clause.  You cannot reference columns of the update relation in the from
clause because the update relation is not named in the from clause.

There is still an underlying “why” here that I don’t know…

David J.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: UPDATE-FROM and INNER-JOIN
  In-Reply-To: <CAKFQuwYcFGgS9itAqsUj5Y02UtDXr8yBtac9w+v+45pLEu4U3Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox