From: LacaK <la...@us...> - 2007-07-02 08:28:42
|
Hi, as we have here FB 2.1 Beta there are 3 release notes (FB15, FB20, FB21) so when I am looking for some statement, function or so, I must go throught these 3 documentation (plus IB60) to find it. It will be helpful include (may be as appendix) *complete list* (not only newly added) of availagle statements, functions (If possible with syntax or reference to FB version, where it changed). Like : DML: INSERT INTO <table> (<columns>) VALUES(<values>) UPDATE <table> SET ... WHERE <expr> DETELE FROM <table or view> WHERE <expr> UPDATE OR INSERT MERGE DDL: CREATE TABLE CREATE PROCEDURE CREATE OR ALTER PROCEDURE CREATE TRIGGER CREATE OR ALTER TRIGGER CREATE VIEW RECREATE TABLE RECREATE PROCEDURE RECREATE TRIGGER RECREATE VIEW ... FUNCTIONS: NUMERIC: ABS(x) LN(x) STRING: POSITION(substring IN string) Position of substring into string SUBSTRING(string FROM position [FOR length]) Substring of given string LPAD, RPAD DATETIME: EXTRACT DATEDIFF DATEADD -Laco. |