Subject Re: [Firebird-Architect] Replace the statement REPLACE
Author Geoff Worboys
> /* REPLACE statement */

> replace
> : REPLACE INTO simple_table_name ins_column_parens_opt
> VALUES '(' value_list ')'
> replace_matching_opt
> returning_clause
> ;

Could you try something like this:

INSERT INTO simple_table_name ins_column_parens_opt
VALUES '(' value_list ')'
[REPLACE WHERE ins_column_parens]
returning_clause
;

That is; make REPLACE just a qualifier on the existing INSERT?

--
Geoff Worboys
Telesis Computing