Fine, thanks it's shorter than mine and works too. I'll adopt it ))
2012/11/7 Alban Hertroys <haram...@gmail.com> > On 7 Nov 2012, at 6:33, Yvon Thoraval wrote: > > > CREATE FUNCTION has_infos(text) RETURNS boolean AS 'select > character_length($1) > 0;' LANGUAGE SQL IMMUTABLE RETURNS FALSE ON NULL > INPUT; > > Try: > CREATE FUNCTION has_infos(text) RETURNS boolean AS 'select > coalesce(character_length($1) > 0, false);' LANGUAGE SQL IMMUTABLE; > > Alban Hertroys > > -- > If you can't see the forest for the trees, > cut the trees and you'll find there is no forest. > > -- Yvon
