On Tuesday, January 1, 2019, Réal A. Carbonneau <contact(at)realcarbonneau(dot)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.