=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <h.otto@xxxxxxxxxxx> writes: > Pg 8.0.3 allows me to compare interval with integer, but I cannot see any > reasonable rule: > 1 < '1 days'::interval The reason that doesn't fail outright is that both integer and interval have implicit coercions to text. So the only interpretation the parser can find is to convert both sides to text and use the text < operator. As text comparisons your answers all make sense. I've been arguing for a long time that we need to cut down on the number of implicit coercions to text... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
