I ran Tom's second script for two hours on an AMD Duron on Linux 2.4.18. No problems.
Gavin ---------------------------(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