Re: UPSERT as a table name is confusing

Re: UPSERT as a table name is confusing

On 8/15/22 8:41 AM, Y Liu wrote:
> RE: https://wiki.postgresql.org/wiki/UPSERT 
> 
> 
> It is really confusing to use UPSERT as a table name in a sql to demo 
> the usage of INSERT INTO UPSERT...ON CONFLICT. How about using a 
> different table name to show the same thing? Just a suggestion.

The page in reference has the following line at the top:

"This Wiki page was only maintained until a few weeks before commit, 
where the patch further evolved in some minor aspects (most notably, the 
syntax became ON CONFLICT DO UPDATE/NOTHING). It is now only of historic 
interest."

(though the wiki is editable).

There are several examples in the docs here with less confusing labeling:

https://www.postgresql.org/docs/current/sql-insert.html

Thanks,

Jonathan

UPSERT as a table name is confusing