Thread: Can a pl/perl function return NULL?

Can a pl/perl function return NULL?

From
"Jeff Eckermann"
Date:
I sure hope so, because I want to index the results of the function, and I
don't want the "nothing" results to be counted in query plans.
I thought "return undef" might do it, but that wasn't recognized as a NULL
in my test.
I can write a pl/pgsql function, but that will take at least five times as
long in this case :-)


Re: Can a pl/perl function return NULL?

From
Alex Pilosov
Date:
According to plperl source code in CVS, it _should_ work (tm). According
to a quick test, it doesn't. I'll do further checking later tonight.

-alex

On Thu, 6 Sep 2001, Jeff Eckermann wrote:

> I sure hope so, because I want to index the results of the function, and I
> don't want the "nothing" results to be counted in query plans.
> I thought "return undef" might do it, but that wasn't recognized as a NULL
> in my test.
> I can write a pl/pgsql function, but that will take at least five times as
> long in this case :-)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>