Re: C function and NULL result

From: Victor Ivanov <v0rbiz(at)icon(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: C function and NULL result
Date: 2000-10-18 07:25:05
Message-ID: 20001018102505.A88421@icon.icon-bg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 17, 2000 at 11:58:50AM -0400, Tom Lane wrote:
> Victor Ivanov <v0rbiz(at)icon(dot)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.

Does elog(ERROR) stops the query? Now my functions return zero values for
illegal input. Anyway, I will use binary access to the data.. I wonder
how does an array look in binary? Is this an easy thing to find in the
source?

--
Players win and Winners play
Have a lucky day

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anatoly K. Lasareff 2000-10-18 08:55:42 Re: select into problem
Previous Message Denis Perchine 2000-10-18 06:23:23 select into problem