Re: C function and NULL result - Mailing list pgsql-general

Victor Ivanov <v0rbiz@icon.bg> writes:
> I'm using PostgreSQL 7.0.2 and I'm trying to create my own types with
> input and output functions in C. Everything works fine, but when the input
> is invalid and the function returns NULL, the backend crashes with SIGSEGV.

You can't return an SQL NULL by returning a NULL pointer.  Right now
there isn't a way for an input converter function to return NULL at all
(this is fixed for 7.1 though).  I'd recommend throwing an elog(ERROR)
if you don't like the input data.

            regards, tom lane