Oliver Jowett <[EMAIL PROTECTED]> writes:
> How about scanning backwards until you have <= 1 choice or decide to
> give up?
Hmm ... that really seems like not a bad idea. Scan all the available
timezones, score each on how far back it goes before a mismatch, take
the one that goes furthest back. I'm not sure what to do about ties,
nor what the minimum "passing score" ought to be, but seems like the
germ of an answer. Comments anyone?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
