SET syntax in INSERT

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SET syntax in INSERT
Date: 2009-08-25 17:10:34
Message-ID: 2c5ef4e30908251010s46d9d566m1da21357891bab3d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2009-08-25 17:36:40 Re: SET syntax in INSERT
Previous Message Melvin Davidson 2009-08-25 16:18:09 Feature / Enhancement request.