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
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 |