Re: Using nulls with earthdistance operator crashes backend

I'll give it a shot and post the patch or let you know I'm stuck. :) Thanks!

-mark

Tom Lane wrote:
>
> Mark Stosberg <mark(at)summersault(dot)com> writes:
> > * Install earthdistance operator from the contrib directory.
> > * try this:
> > cascade=> select null <@> '1,1'::point;
>
> > ## The result I get:
> > pqReadData() -- backend closed the channel unexpectedly.
>
> Probably the earthdistance functions are not NULL-safe and need to be
> marked "isStrict" in CREATE FUNCTION. Would you be willing to do the
> legwork on working up a patch for that?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--

http://mark.stosberg.com/