Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Is there any reason why the 'ON COMMIT' behaviour feature is not > available if you use CREATE TABLE AS ...?
Where exactly would you propose to stick it in the syntax? Can you do it without introducing more fully-reserved words than we have already? Is there any spec or other-product precedent for it? (Offhand I can't even find CREATE TABLE AS in SQL99...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match