Re: Can a pl/perl function return NULL?

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Jeff Eckermann <jeckermann(at)verio(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can a pl/perl function return NULL?
Date: 2001-09-06 20:05:24
Message-ID: Pine.BSO.4.10.10109061559250.1116-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org)
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-09-06 20:13:46 Re: template0 and template1 databases
Previous Message Ian Harding 2001-09-06 19:56:58 SQL Server to PostgreSQL HOWTO