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.
I see there request on package functions, that can be realised with our schemas - schema function is +/- equal - and better support for package variables - there is a patch for schema session variables.
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.