Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > I've been wondering about that. A while ago the change was made from > outputting a NOTICE with the EXPLAIN output to returning a resultset. > If you could agree on what columns to return it might not be so hard > for the EXPLAIN to return full tuples... The major stumbling block to that is that a table is inherently unordered, so you'd have to devise a labeling scheme to allow the node-tree structure to be represented properly. And without WITH or CONNECT BY, it'd be a bit of a PITA for an application to decipher the labeling scheme again ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)