On Wed, Oct 8, 2008 at 3:56 PM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am Wed, dem 08.10.2008, um 14:29:23 -0400 mailte Alvaro Herrera folgendes: >> Hi, >> >> Trigger functions are supposed to be able to be called only as triggers, >> but apparently the check is not working in CVS HEAD: >> >> alvherre=# create or replace function foo () returns trigger as $$ begin >> perform 1; return new; end; $$ language plpgsql; >> CREATE FUNCTION >> alvherre=# select foo(); >> foo >> ----- >> >> (1 fila) > > > And? > > The function returns a TRIGGER, not a value. >
actually, that means that you can return undefined values for NEW and OLD...and worse you can update other tables based on undefined NEW/OLD values? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
