From: Jim S. <ja...@ne...> - 2005-10-31 16:18:06
|
Adriano dos Santos Fernandes wrote: > V > >> Only solution i can imagine is to enable this ability >> (control-of-flow statements in usual SQL) only for non-select >> statements and treat it on client as EXECUTE BLOCK without outputs >> (isc_info_sql_stmt_exec_procedure). In fact such statements are very >> similar to simple EXECUTE BLOCK statement >> >> >> 2) SUSPEND AND EXIT must be disabled inside SQL-version of >> IF and WHILE >> >> This is can be relatively easyly done in parser.y >> Am i missing something ? Opinions ? >> >> > We don't support DDL inside PSQL. > Do DDL will work with IF, for example? DDL and DML have completely independent execution paths. DDL gets turned into DYN that is eventually interpreted, though most of the interesting work is deferred until commit time. DML gets turned into blr then translated into execution structure and interpreted by looper. The two mechanism are, and should be, completely separate. These are relatively minor implementation problems. The larger issues are logical and architectural. -- Jim Starkey Netfrastructure, Inc. 978 526-1376 |