Jian He <hejian.m...@gmail.com> writes: >> for that means the following sql queries should return* false:*
>> select mytyperange ( >> (1,'2022-01-01')::mytype, >> (8, '2022-01-31')::mytype, '[]') @> (2, '2020-01-19')::mytype; Why should that return false? The comparison rules for composites say that you compare the first column, only if that's equal compare the second, etc. Here, "2" is between "1" and "8" so the contents of the second column don't matter. regards, tom lane