Limin Liu <[EMAIL PROTECTED]> writes: > I just realized that INSERT allows us to have more syntax than the > manual said. I wonder if we want to elimiate it or keep it with more > documentation on the INSERT statment? This will likely go away when we get around to upgrading INSERT to the full SQL spec --- certainly I'd feel no compunction about removing any non-SQL syntax that happens to be supported now, if it gets in the way of spec compliance. In short, no I don't want to document it, because I don't want people to start relying on it. > For the first one, I believe that is due to reusing the definition of > target_list/target_el. Yes. There's not a lot of difference in the implementations of INSERT ... VALUES and INSERT ... SELECT, at the moment. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster