Subject Re: [Firebird-Architect] Replace the statement REPLACE
Author Arno Brinkman
Hi,

> 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