News for hackers. Stuff that matters.

A comment on Oracle vs. PostgreSQL: First Glance.

Re:Oracle vs. PostgreSQL: First Glance by dx034 on Monday May 04, 2020 @08:37AM (#23067182)
> -- By EXCLUDED.email we could refer to the "old" email value that we are updating.

Small nitpick: The excluded table contains the values proposed for insertion, not the values already present in the table (as described in [1]).

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

[ Parent | on HN ]
Re:Oracle vs. PostgreSQL: First Glance by takacsroland on Monday May 04, 2020 @06:21PM (#23074057)
You are right, I already corrected this. Thanks.
[ Parent | on HN ]