Josh Berkus <josh@agliodbs.com> writes: > That sounds good if it works. However ... will an add_missing_from view work > if add_missing_from is off in the session where the query is executed?
Yes, you only need to get it past the parser during CREATE VIEW. 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