Karsten Hilbert wrote:
> Hi all,
>
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
> returns trigger
> language plpgsql
> as $null_empty_title$
> begin
> if (NEW.title is null) then
> return NEW;
> end if;
>
> if trim(NEW.title) <> '' then
> return NEW;
> end if;
>
> NEW.title := NULL;
> return NEW;
> end;
> $null_empty_title$;
Works for me ...
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support