Re: Returning NULL to a set returning C type function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bborie Park <bkpark(at)ucdavis(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Returning NULL to a set returning C type function
Date: 2011-05-11 18:23:39
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Bborie Park <bkpark(at)ucdavis(dot)edu> writes:
> I have a C type function that returns a set of a type. The problem I
> have is that the underlying function may return NULL. When the
> underlying function returns NULL, I get the error message:

> ERROR: function returning set of rows cannot return null value

> I'm wondering what is the proper way to correct this problem?

Don't do that ;-). You could choose either to not return any row
at all when this happens, or to construct an all-nulls row to return.
ExecMakeTableFunctionResult doesn't want to guess which behavior is
appropriate for your use-case, so it just complains.

regards, tom lane

In response to


Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-05-11 18:59:51 Re: Regexp match not working.. (SQL help)
Previous Message Michael Nolan 2011-05-11 18:10:16 Re: Query to return every 1st Sat of a month between two dates