SET syntax in INSERT
От | Rob Wultsch |
---|---|
Тема | SET syntax in INSERT |
Дата | |
Msg-id | 2c5ef4e30908251010s46d9d566m1da21357891bab3d@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: SET syntax in INSERT
|
Список | pgsql-hackers |
Given the recent discussion of "DELETE syntax on JOINS" I thought it might be interesting to bring a bit MySQL syntax that is in somewhat widespread use, generally create somewhat cleaner code and I imagine would not break much if implemented. MySQL allows INSERTs of the form: INSERT INTO t SET col1='val1', col2='va21', col3='val3', col4='val4', col5='val5', col6='val6', col7='val7', col8='val8', col9='val9', col10='val10', col11='val11', col12='val12', col13='val13', col14='val14', col15='val15'; Which I think sometimes compares very favorably INSERT INTO t (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15) VALUES ('val1','val2','val3','val4','val5','val6','val7','val8','val9','val10','val11','val12','val13','val14','val15') Probably a pipe dream... -- Rob Wultsch wultsch@gmail.com
В списке pgsql-hackers по дате отправления: