Returning NULL to a set returning C type function

From: Bborie Park <bkpark(at)ucdavis(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Returning NULL to a set returning C type function
Date: 2011-05-11 18:01:33
Message-ID: 4DCACEFD.1050401@ucdavis.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? Or is
there are correct workaround?

So, for my sample code:

CREATE TYPE histogram AS (
min double precision,
max double precision,
count integer,
proportion double precision
);

CREATE OR REPLACE FUNCTION _st_histogram(rast raster, nband int,
hasnodata boolean, sample_percent double precision, bins int, width
double precision[], right boolean)
RETURNS SETOF histogram
AS '$libdir/rtpostgis-2.0','RASTER_histogram'
LANGUAGE 'C' IMMUTABLE STRICT;

PG_FUNCTION_INFO_V1(RASTER_histogram);
Datum RASTER_histogram(PG_FUNCTION_ARGS)
{
-- if any of the args are incorrect, return NULL
PG_RETURN_NULL();
}

Thanks,
Bborie

--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark(at)ucdavis(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2011-05-11 18:10:16 Re: Query to return every 1st Sat of a month between two dates
Previous Message Oleg Bartunov 2011-05-11 17:42:44 Re: full text search to_tsquery performance with ispell dictionary