Re: [SQL] HI! Problems with cursors into triggers

2000-06-28 Thread Robert B. Easter
On Wed, 28 Jun 2000, Andrés Mauricio Marín Restrepo wrote: > > HELLO! > > I'm making one trigger (plpgsql) and in the function i use CURSOR for to > > bring an elements and to take them to a variable but no me it does not > work, WHY? > > The script is: > > DROP TRIGGER miTrig on

[SQL] HI! Problems with cursors into triggers

2000-06-28 Thread Andrés Mauricio Marín Restrepo
HELLO! I'm making one trigger (plpgsql) and in the function i use CURSOR for to bring an elements and to take them to a variable but no me it does not work, WHY? The script is: DROP TRIGGER miTrig on otro; DROP FUNCTION miFunc(); DROP TABLE otro; DROP TABLE cual; CREATE TABLE otro

[SQL] HI! Problems with cursors into triggers

2000-06-27 Thread Andrés Mauricio Marín Restrepo
HELLO! I'm making one trigger (plpgsql) and in the function i use CURSOR for to bring an elements and to take them to a variable but no me it does not work, WHY? The script is: DROP TRIGGER miTrig on otro; DROP FUNCTION miFunc(); DROP TABLE otro; DROP TABLE cual; CREATE TABLE otro