On Tuesday, January 1, 2019, Réal A. Carbonneau <
contact@realcarbonneau.com> wrote:
Since CREATE ... OR REPLACE is literally: "if exists, drop and create, else, create",
It’s specifically saying “replace the query used for the view without changing the view signature/type”. Same goes for create or replace function. The point being the signature is public and cannot be changed on the fly but the implementation can be replaced.
David J.