Subject | Re: [Firebird-Architect] Replace the statement REPLACE |
---|---|
Author | Arno Brinkman |
Post date | 2006-11-17T23:30:32Z |
Hi,
replace
: REPLACE INTO simple_table_name ins_column_parens_opt
VALUES '(' value_list ')'
replace_matching_opt
returning_clause
;
replace_matching_opt
: MATCHING ins_column_parens
|
;
returning_clause : RETURNING value_list
| RETURNING value_list INTO variable_list
|
;
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com
Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info
> Could somebody post Vlad's syntax and semantics?/* REPLACE statement */
replace
: REPLACE INTO simple_table_name ins_column_parens_opt
VALUES '(' value_list ')'
replace_matching_opt
returning_clause
;
replace_matching_opt
: MATCHING ins_column_parens
|
;
returning_clause : RETURNING value_list
| RETURNING value_list INTO variable_list
|
;
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com
Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info