On Fri, Jan 13, 2017 at 7:24 PM, Peter Geoghegan <pg@heroku.com> wrote:
MERGE isn't UPSERT, and isn't even in competition with UPSERT as a feature. I've written reams of text explaining why this is so in precise detail, ...
Hello,
This is the webinar that started this whole thread (well the original thread, not this weird MERGE/UPSERT stuff):
Thank you to everyone that responded. You will see in this Webinar that at least from the Oracle people perspective, PostgreSQL is not an option unless it has packages.
The other item that people bring up a few times is Oracle Forms but as that is actually external (although dependent) on Oracle, I don't see that as our responsibility.
Now I am working with Oracle application - and I try to understand to Oracle developers - often pattern is using "Oracle schema" as database - and then the packages has sense. But there is not a mapping "Oracle schema" = "PostgreSQL schema" - and packages is a redundant concept in Postgres (and in all db, where the schema are like namaspace - MSSQL, DB2, MySQL).
Regards
Pavel
Sincerely,
JD
-- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own.