Re: Issue with point_ops and NaN - Mailing list pgsql-hackers

On Thu, 2021-04-01 at 09:35 +0900, Kyotaro Horiguchi wrote:
> > > > > > > > SELECT point('NaN','NaN') <@ polygon('(0,0),(1,0),(1,1),(0,0)');
> > > > > > > > ?column? 
> > > > > > > > ----------
> > > > > > > >    t
> > > > > > > >    (1 row)
> > 
> > If you think of "NaN" literally as "not a number", then FALSE would
> > make sense, since "not a number" implies "not a number between 0 and 1".
> > But since NaN is the result of operations like 0/0 or infinity - infinity,
> > NULL might be better.
> > So I'd opt for NULL too.
> 
> Thanks.  Do you think it's acceptable that returning false instead of
> NULL as an alternative behavior?

Yes, I think that is acceptable.

Yours,
Laurenz Albe