Create Rule

From: Fernando San Martín Woerner <snmartin(at)galilea(dot)cl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Create Rule
Date: 2001-11-15 15:51:13
Message-ID: EEECJAMPNEKNFFFDPKFEEEPICBAA.snmartin@galilea.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i'm trying to do this

CREATE RULE borra_presupuesto AS ON DELETE TO presupuesto DO INSTEAD
(UPDATE presupuesto SET en_uso = 'False' WHERE cod_presupuesto =
old.cod_presupuesto;
UPDATE detalle_presupuesto SET en_uso = 'False' WHERE cod_presupuesto =
old.cod_presupuesto);

but i get this error:

ERROR: parser: parse error at or near ""

any tips?

thanks

Fernando San Martín Woerner
Jefe Depto. Informática
Galilea S.A.
counter.li.org Linux User #216550
----------------------------------------
Una era construye ciudades, una hora las destruye.

Séneca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-11-15 15:53:20 Re: Modifying check constraints
Previous Message Cristóvão Dalla Costa 2001-11-15 15:50:01 Re: GUI?