2009/11/25 Jason Armstrong <ja@xxxxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
