"Shuo Liu" <[EMAIL PROTECTED]> writes: > Thank you so much for pointing out the problems. The first one seems very > silly :-(. For the second one, I may stay out of trouble if I don't use > transform() at all (I can tolerate some error without transform), am I right?
Hmm, I wouldn't suggest removing functionality to work around a bug that presumably will get fixed soon. It's not that common to run out of memory (else this bug would've been found long ago), so I think you could just live with it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match