Michael Fuhr <[EMAIL PROTECTED]> writes: > While investigating somebody's question I ran the following query, > which caused the backend to segfault:
> SELECT * FROM foo WHERE first_date <= now() AND last_date >= now(); > I have to run so I can't put together a test case right now, but > here's the stack trace: > #0 convert_timevalue_to_scalar (value=1913, typid=1184) at selfuncs.c:2816 > #1 0x81aa3e5 in convert_to_scalar (value=138003712, valuetypid=1184, > scaledvalue=0xbfbfea50, > lobound=1913, hibound=1951, boundstypid=1082, scaledlobound=0xbfbfea58, > scaledhibound=0xbfbfea60) at selfuncs.c:2393 Mumble ... that patch I put in last week doesn't work at all, does it? Back to the drawing board. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster