Hi, David, On Tue, Jul 3, 2018 at 1:46 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: > On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote: >> >> >> I presume threre is a query which check for the function/trigger >> existence? Something like: >> >> IF NOT EXIST(SELECT * FROM ) CREATE OR REPLACE FUNCTION....; > > > CREATE OR REPLACE is how you re-create a function that (whose > name/signature) might already exist; CREATE already assumes one doesn't > exist. Why do I need to re-create a function with exactly the same name and body? Can't I just check if such function exists? Thank you. > > David J. >
