From: | "Christian Ortiz" <cpalst(at)gmail(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Cacenlar un insert |
Date: | 2008-02-01 13:49:30 |
Message-ID: | 655c646a0802010549h3bdf3d29rdc54ac206372994b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Gracias, si trabaja :
CREATE OR REPLACE FUNCTION SPCreaPago() RETURNS "trigger"
AS $STsoft$
declare
BEGIN
IF NEW.pagoMontoTotal>0 then
return new;
ELSE
return null;
END IF;
END;
$STsoft$
LANGUAGE 'plpgsql';
CREATE TRIGGER t_pagos BEFORE INSERT ON STpago
FOR EACH ROW EXECUTE PROCEDURE SPCreaPago();
2008/2/1, Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>
> Christian Ortiz escribió:
>
> > trato d ehacer un trigger q bajo cierta condicion , permita la insercion
> o
> > la descarte:
>
> RETURN NULL;
>
> Cuando quieres que no la cancele,
>
> RETURN NEW;
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
--
Christian
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-02-01 14:08:36 | Re: salto de linea en copy problema |
Previous Message | Alvaro Herrera | 2008-02-01 13:39:42 | Re: Cacenlar un insert |