Re: [GENERAL] Excluding null return values from functions

2009-11-25 Thread Pavel Stehule
2009/11/25 Jason Armstrong : > How do I give a condition on the return value of a function (for > example plperl)? > > I have a perl search function that returns either a bigint, or undef > if nothing is found. I want to exclude the undef/null return values > from my select statement, something lik

[GENERAL] Excluding null return values from functions

2009-11-25 Thread Jason Armstrong
How do I give a condition on the return value of a function (for example plperl)? I have a perl search function that returns either a bigint, or undef if nothing is found. I want to exclude the undef/null return values from my select statement, something like: sql> select search(data, 'field', 'v