Re: Install new perl test function in PostgreSQL - Mailing list pgsql-novice

Jignesh Shah wrote:

Thanks I will try it today and get back here in case of any problems. I
could see "CREATE OR REPLACE" in every trigger example. I am wondering why
we need REPLACE? What is it purpose?

Thanks,
Jignesh

It is fairly common to modify functions several times before they are
finalised. Using OR REPLACE simply allows you to do it in one step,
instead of DROP FUNCTION... CREATE FUNCTION... every time you change
something.

The OR REPLACE is only an option, you don't have to use it if you don't
want to.

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz