trythis2.sql

text/english

Filename: trythis2.sql

Type: text/english

Part: 3

Message: PostgreSQL crashes using distance operator whith records where 'point' data type set to null

select * from foo where text='hello0' and ( (bar is not null and (bar<->point(0,0) ) < 1000) or ( bar2 is not null and (bar2<->point(0,0)) < 1000)); 
select * from foo where text='hello1' and ( (bar is not null and (bar<->point(0,0) ) < 1000) or ( bar2 is not null and (bar2<->point(0,0)) < 1000)); 
select * from foo where text='hello2' and ( (bar is not null and (bar<->point(0,0) ) < 1000) or ( bar2 is not null and (bar2<->point(0,0)) < 1000));