Le jeu. 1 avr. 2021 à 15:54, Laurenz Albe <laurenz.a...@cybertec.at> a écrit :
> 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. > +1 especially after looking at the poc patch you sent to handle NULLs. >