Thread: Excluding null return values from functions

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', 'value') as result from mydata where
result is not null;

--
Jason Armstrong

2009/11/25 Jason Armstrong <ja@riverdrums.com>:
> 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', 'value') as result from mydata where
> result is not null;

select result from (select  search(data, 'field','value') as result
from mydata) x where result is not null;

regards
Pavel Stehule

>
> --
> Jason Armstrong
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>