Re: trigger help

Micheal


> This isn't a trigger function.  Are you sure
> "trigger" is the
> word you meant?

 yes i do



CREATE TABLE actlocat
(
  id_actlocal numeric(2) NOT NULL,
  d_actlocal char(8) NOT NULL,
  f_novedad float8 NOT NULL,
  ordenado_por char(18) NOT NULL,
  CONSTRAINT pk_actlocat PRIMARY KEY (id_actlocal)
)
WITHOUT OIDS;
ALTER TABLE actlocat OWNER TO postgres;

CREATE TRIGGER sume_create_cache_actlocat_trigger
  AFTER UPDATE
  ON actlocat
  FOR EACH ROW
  EXECUTE PROCEDURE
xxxx_create_cache_actlocat_trigger_function();

.
.
.


CREATE OR REPLACE FUNCTION
xxxx_create_cache_actlocat_trigger_function()
  RETURNS "trigger" AS
$BODY$
  BEGIN
    PERFORM
xxxx_create_cache(lower(NEW.d_actlocal)::text);
    RAISE NOTICE
'xxxx_create_cache_actlocat_trigger_function(%)',
lower(NEW.d_actlocal)::text;
        RETURN NULL;
  END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION s

best regards
 MDC





__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas