Simon Riggs wrote: > OK, thats what I hoped you'd say. With a prepared query all of the > statements execute the same plan, so you don't need to know the exact > parameters.
This isn't true in 8.0 if you are using the unnamed statement (as the JDBC driver does in some cases): the plan chosen depends on the parameter values given in the first Bind. -O ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster