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
