Re: Using nulls with earthdistance operator crashes backend - Mailing list pgsql-bugs

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@summersault.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@postgresql.org)

--

http://mark.stosberg.com/