aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/backend/parser/gram.y78
1 files changed, 74 insertions, 4 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
index f53ba9ce60d..eab360bc774 100644
--- a/src/backend/parser/gram.y
+++ b/src/backend/parser/gram.y
@@ -11,7 +11,7 @@
*
*
* IDENTIFICATION
- * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.560 2006/09/02 18:17:17 momjian Exp $
+ * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.561 2006/09/02 20:34:47 momjian Exp $
*
* HISTORY
* AUTHOR DATE MAJOR EVENT
@@ -237,7 +237,8 @@ static void doNegateFloat(Value *v);
name_list from_clause from_list opt_array_bounds
qualified_name_list any_name any_name_list
any_operator expr_list attrs
- target_list update_target_list insert_column_list
+ target_list update_col_list update_target_list
+ update_value_list insert_column_list
values_list def_list indirection opt_indirection
group_clause TriggerFuncArgs select_limit
opt_select_limit opclass_item_list
@@ -308,7 +309,8 @@ static void doNegateFloat(Value *v);
%type <jexpr> joined_table
%type <range> relation_expr
%type <range> relation_expr_opt_alias
-%type <target> target_el update_target_el insert_column_item
+%type <target> target_el update_target_el update_col_list_el insert_column_item
+%type <list> update_target_lists_list update_target_lists_el
%type <typnam> Typename SimpleTypename ConstTypename
GenericType Numeric opt_float
@@ -5537,6 +5539,20 @@ UpdateStmt: UPDATE relation_expr_opt_alias
n->returningList = $7;
$$ = (Node *)n;
}
+ | UPDATE relation_expr_opt_alias
+ SET update_target_lists_list
+ from_clause
+ where_clause
+ returning_clause
+ {
+ UpdateStmt *n = makeNode(UpdateStmt);
+ n->relation = $2;
+ n->targetList = $4;
+ n->fromClause = $5;
+ n->whereClause = $6;
+ n->returningList = $7;
+ $$ = (Node *)n;
+ }
;
@@ -5941,6 +5957,60 @@ values_item:
| DEFAULT { $$ = (Node *) makeNode(SetToDefault); }
;
+update_target_lists_list:
+ update_target_lists_el { $$ = $1; }
+ | update_target_lists_list ',' update_target_lists_el { $$ = list_concat($1, $3); }
+ ;
+
+update_target_lists_el:
+ '(' update_col_list ')' '=' '(' update_value_list ')'
+ {
+ ListCell *col_cell;
+ ListCell *val_cell;
+
+ if (list_length($2) != list_length($6))
+ {
+ ereport(ERROR,
+ (errcode(ERRCODE_SYNTAX_ERROR),
+ errmsg("number of columns does not match to number of values")));
+ }
+
+ for (col_cell = list_head($2), val_cell = list_head($6);
+ col_cell != NULL && val_cell != NULL;
+ col_cell = lnext(col_cell), val_cell = lnext(val_cell))
+ {
+ /* merge update_value_list with update_col_list */
+ ResTarget *res_col = (ResTarget *) lfirst(col_cell);
+ ResTarget *res_val = (ResTarget *) lfirst(val_cell);
+
+ res_col->val = (Node *)copyObject(res_val);
+ }
+
+ $$ = $2;
+ }
+ ;
+
+update_col_list:
+ update_col_list_el { $$ = list_make1($1); }
+ | update_col_list ',' update_col_list_el { $$ = lappend($1, $3); }
+ ;
+
+update_col_list_el:
+ ColId opt_indirection
+ {
+ $$ = makeNode(ResTarget);
+ $$->name = $1;
+ $$->indirection = $2;
+ $$->val = NULL;
+ $$->location = @1;
+ }
+ ;
+
+update_value_list:
+ values_item { $$ = list_make1($1); }
+ | update_value_list ',' values_item { $$ = lappend($1, $3); }
+ ;
+
/*****************************************************************************
*
@@ -8253,7 +8323,7 @@ target_el: a_expr AS ColLabel
;
update_target_list:
- update_target_el { $$ = list_make1($1); }
+ update_target_el { $$ = list_make1($1); }
| update_target_list ',' update_target_el { $$ = lappend($1,$3); }
;