Re: trigger functions broken?

On Wed, Oct 8, 2008 at 3:56 PM, A. Kretschmer
<andreas(dot)kretschmer(at)schollglas(dot)com> 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