Re: edit function

On Sep 7, 2009, at 2:26 AM, Rakotomandimby Mihamina wrote:

> I have a function like this:
>
> CREATE FUNCTION f_active_client(character varying)
> RETURNS character varying
> AS $_$
> DECLARE
> v_modem ALIAS FOR $1;
> v_firstuse BOOLEAN;
> v_admactive BOOLEAN;
> v_codeclt varchar;
> BEGIN
> SELECT INTO (...)
> IF FOUND THEN
> (...)
> ELSE
> RETURN 'ERROR';
> END IF;
> END;
> $_$
>
>
> I have to insert several IF statements in the "IF FOUND" one.
> I wont do it one time, I will insert them one by one.
>
> I cannot stop too much long the PG server (a /etc/init.d restart
> time is OK, more is not)
>
> Dumping and the restoring is not possible because of too long
> downtime.
>
> DELETing CREATing the function is not possible because of dependency.
>
> When looking at the help, '\h' has no REPLACE FUNCTION.
> Only ALTER FUNCTION
>
> How to manage it?

Write it exactly as you have above, but replace the first line with:

CREATE OR REPLACE FUNCTION f_active_client(character varying)

John DeSoi, Ph.D.