>Вторник, 5 июля 2022, 18:29 +03:00 от Tom Lane :
>
>=?UTF-8?B?U3ZldGxhbmEgRGVyZXZ5YW5rbw==?= < s.derevya...@postgrespro.ru >
>writes:
>> It seems useful to have [OR REPLACE] option in CREATE OPERATOR statement, as
>> in CREATE FUNCTION. This option may be good for writing extension update
Hi,
Svetlana, yes, Tom means that CREATE OR REPLACE should always produce
the same result no matter which branch actually worked - CREATE or REPLACE.
REPLACE case must produce exactly the same result as you've mentioned -
DROP and CREATE.
As for IF NOT EXISTS option I agree, it seems a reasonable