Simon Riggs <[EMAIL PROTECTED]> writes: > There once was a rumour of a EXPLAIN EXECUTE command. > This minor patch removes all trace of that, but without disturbing other > valid occurrences of the EXECUTE command, which still lives on.
It's not as dead as you seem to think. regression=# prepare foo as select * from tenk1; PREPARE regression=# explain execute foo; QUERY PLAN ------------------------------------------------------------- Seq Scan on tenk1 (cost=0.00..458.00 rows=10000 width=244) (1 row) regression=# 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