Support setting a particular ARRAY element in UPSERT

[jtaylor-sfdc]

Support setting a particular element array in an UPSERT call like this:

UPSERT FROM my_table(name, pay_by_quarter[4]) 
SELECT name,15000 FROM my_table
WHERE name = 'Carol';

[ramkrish86]

Thanks James. Will take this up once my current activities are done.

[jtaylor-sfdc]

I think a good first step is supporting this syntax in UPSERT SELECT and UPSERT VALUES:

UPSERT FROM my_table(name, pay_by_quarter[4]) 
SELECT name,15000 FROM my_table
WHERE name = 'Carol';

Basically allowing an array subscript in addition to a column name. We can do the UPSERT SET command after our 3.0 release.