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)
>
>
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 |