Request a Demo
Home   >   mailing lists

Re: Returning NULL to a set returning C type function - Mailing list pgsql-general

From Bborie Park
Subject Re: Returning NULL to a set returning C type function
Date
Msg-id 4DCADEE1.6090901@ucdavis.edu
Whole thread Raw
In response to Re: Returning NULL to a set returning C type function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> 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
>

Thanks Tom.  I'll go the "no return any row" route.

--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark@ucdavis.edu

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Regexp match not working.. (SQL help)
Next
From: Cédric Villemain
Date:
Subject: Re: track functions call