Denis Vlasenko <[EMAIL PROTECTED]> writes: > On Wednesday 13 July 2005 17:43, Tom Lane wrote: >> The reason it cannot be done transparently is that you would lose the >> guarantee that a query either succeeds or fails: it would be entirely >> possible to return some rows to the application and only later get a >> failure.
> What failures are likely? Consider select x, 1/x from foo; where x is zero in the 10,000'th row ... 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