search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
559 stars 227 forks source link

how can i use UPSERT VALUES? #739

Open mmaxiaolei opened 9 years ago

mmaxiaolei commented 9 years ago

i user the sentence; "UPSERT VALUES INTO my_table(id, col1, col2) VALUES( NEXT VALUE FOR my_schema.my_sequence, 'foo', 'bar');" from "http://phoenix.apache.org/sequences.html". but ,it do not work,bugs:Error: ERROR 603 (42P00): Syntax error. Unexpected input. Expecting "INTO", got "VALUES" at line 1, column 8. (state=42P00,code=603) can you tell me why?

jtaylor-sfdc commented 9 years ago

Phoenix moved to Apache a year ago. Please subscribe to our email address there instead, as this one is no longer active: http://phoenix.apache.org/mailing_list.html

On Dec 25, 2014, at 10:37 PM, mmaxiaolei notifications@github.com wrote:

i user the sentence; "UPSERT VALUES INTO my_table(id, col1, col2) VALUES( NEXT VALUE FOR my_schema.my_sequence, 'foo', 'bar');" from "http://phoenix.apache.org/sequences.html". but ,it do not work,bugs:Error: ERROR 603 (42P00): Syntax error. Unexpected input. Expecting "INTO", got "VALUES" at line 1, column 8. (state=42P00,code=603) can you tell me why?

— Reply to this email directly or view it on GitHub https://github.com/forcedotcom/phoenix/issues/739.