제목 그대로 Firebird 1.5 Language Reference입니다. 7월 4일자로 업데이트된 거네요.
목차는 다음과 같습니다.
1. Introduction
Versions covered
Authorship
2. Reserved words
Added in 1.0 but removed in 1.5
Added in 1.0 and 1.5
To be added in future versions
3. Miscellaneous language elements
-- (single-line comment)
CASE construct
4. Data types and subtypes
BIGINT data type
New character sets
Character set NONE handling changed
New collations
5. DDL statements
ALTER TABLE
ALTER TRIGGER
CREATE DATABASE
CREATE GENERATOR
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE OR ALTER PROCEDURE
CREATE OR ALTER TRIGGER
DECLARE EXTERNAL FUNCTION
DROP GENERATOR
DROP TRIGGER
RECREATE PROCEDURE
RECREATE TABLE
RECREATE VIEW
6. DML statements
EXECUTE PROCEDURE
RELEASE SAVEPOINT
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
7. PSQL statements
BEGIN ... END blocks may be empty
BREAK
DECLARE [VARIABLE] with initialization
EXCEPTION
EXECUTE PROCEDURE
EXECUTE STATEMENT
EXIT
FOR EXECUTE STATEMENT ... DO
LEAVE
PLAN allowed in trigger code
8. Context variables
CURRENT_CONNECTION
CURRENT_ROLE
CURRENT_TRANSACTION
CURRENT_USER
DELETING
GDSCODE
INSERTING
ROW_COUNT
SQLCODE
UPDATING
9. Internal functions
COALESCE()
EXTRACT()
NULLIF()
SUBSTRING()
10. External functions (UDFs)
addDay
addHour
addMilliSecond
addMinute
addMonth
addSecond
addWeek
addYear
ascii_char
dow
dpower
getExactTimestamp
i64round
i64truncate
log
lpad
ltrim
*nullif
*nvl
right
round, i64round
rpad
rtrim
sdow
string2blob
substr
substrlen
truncate, i64truncate
A. Notes
Character set NONE data accepted “as is”
Understanding the WITH LOCK clause
A note on CSTRING parameters
B. Document History
C. License notice
온라인 html 버전은 다음 위치에서 보실 수 있습니다.
http://www.firebirdsql.org/refdocs/langrefupd15.html
|