The Pyrrho Database Management System

Malcolm Crowe, University of the West of Scotland

 

Reserved Words

Pyrrho treats all of the following as reserved words:

ABS, ALL, ALLOCATE, ALTER, AND, ANY, ARE, ARRAY, ARRAY_MAX_CARDINALITY, AS, ASENSITIVE, ASYMMETRIC, AT, ATOMIC, AUTHORIZATION, AVG, BEGIN, BEGIN_FRAME, BEGIN_PARTITION, BETWEEN, BIGINT, BINARY, BLOB, BOOLEAN, BOTH, BY, CALL, CALLED, CARDINALITY, CASCADED, CASE, CAST, CEIL, CEILING, CHAR, CHARACTER, CHARACTER_LENGTH, CHAR_LENGTH, CHECK, CLOB, CLOSE, COALESCE, COLLATE, COLLECT, COLUMN, COMMIT, CONDITION, CONNECT, CONSTRAINT, CONVERT, CORR, CORRESPONDING, COUNT, COVAR_POP, COVAR_SAMP, CREATE, CROSS, CUBE, CUME_DIST, CURRENT, CURRENT_CATALOG, CURRENT_DATE, CURRENT_DEFAULT_TRANSFORM_GROUP, CURRENT_PATH, CURRENT_ROLE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_TRANSFORM_GROUP_FOR_TYPE, CURRENT_USER, CURSOR, CYCLE, DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DELETE, DENSE_RANK, DEREF, DESCRIBE, DETERMINISTIC, DISCONNECT, DISTINCT, DO, DOCARRAY, DOCUMENT, DOUBLE, DROP, DYNAMIC, EACH, ELEMENT, ELSE, ELSIF, END, END_FRAME, END_PARTITION, EOF, EQUALS, ESCAPE, EVERY, EXCEPT, EXEC, EXECUTE, EXISTS, EXIT, EXP, EXTERNAL,  EXTRACT, FALSE, FETCH,  FILTER,  FLOAT, FLOOR,  FOR,  FOREIGN, FREE,  FROM,  FULL, FUNCTION, FUSION, GET,  GLOBAL,  GRANT,  GROUP,  GROUPING, GROUPS, HAVING, HOLD, HOUR, HTTP, IDENTITY,  IF, IN, INDICATOR, INNER, INOUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTERSECTION, INTERVAL, INTO, IS, JOIN, LANGUAGE, LARGE, LAST_VALUE, LATERAL, LEADING, LEAVE, LEFT, LIKE, LIKE_REGEX, LN, LOCAL, LOCALTIME, LOCALTIMESTAMP, LOOP, LOWER, MATCH, MAX, MEMBER, MERGE, METHOD, MIN, MINUTE, MOD, MODIFIES, MODULE, MONTH, MULTISET, NATIONAL, NATURAL, NCHAR, NCLOB, NEW, NO, NONE, NORMALIZE, NOT, NTILE, NULL, NULLIF, NUMERIC, OBJECT, OCCURRENCES_REGEX, OCTET_LENGTH, OF, OFFSET, OLD, ON, ONLY, OPEN, OR, ORDER, OUT, OUTER, OVER, OVERLAPS, OVERLAY, PARAMETER, PARTITION, PASSWORD, PERCENT, PERCENT_RANK, PERCENTILE_CONT, PERCENTILE_DISC, PERIOD, PORTION, POSITION, POSITION_REGEX, POWER, PRECISION, PREPARE, PRIMARY, PROCEDURE, RANGE, RANK, READS, REAL, RECURSIVE, REF, REFERENCES, REFERENCING, REGR_AVGX, REGR_AVGY, REGR_COUNT, REGR_INTERCEPT, REGR_R2, REGR_SLOPE, REGR_SXX, REGR_SXY, REGR_SYY, RELEASE,  RESIGNAL, RESULT, RETURN, RETURNS, REVOKE, RIGHT, ROLLBACK, ROLLUP, ROW, ROW_NUMBER, ROWS, ROW_NUMBER, SAVEPOINT, SCOPE, SCROLL, SEARCH, SECOND, SELECT, SENSITIVE, SESSION_USER, SET, SIMILAR, SMALLINT, SOME, SPECIFIC, SPECIFICTYPE, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, SQRT, START, STATIC, STDDEV_POP, STDDEV_SAMP, SUBMULTISET, SUBSTRING, SUBSTRING_REGEX, SUCCEEDS, SUM, SYMMETRIC, SYSTEM, SYSTEM_TIME, SYSTEM_USER, TABLE, TABLESAMPLE, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO, TRAILING, TRANSLATE, TRANSLATE_REGEX, TRANSLATION, TREAT, TRIGGER, TRIM, TRIM_ARRAY, TRUE, TRUNCATE, UESCAPE, UNION,  UNIQUE, UNKNOWN, UNNEST, UNTIL, UPDATE, UPPER, USER, USING, VALUE, VALUES, VALUE_OF, VAR_POP, VAR_SAMP, VARBINARY, VARCHAR, VARYING, VERSIONING, WHEN, WHENEVER, WHERE, WHILE, WIDTH_BUCKET, WINDOW, WITH, WITHIN, WITHOUT, XML, XMLAGG, XMLATTRIBUTES, XMLBINARY, XMLCAST, XMLCOMMENT, XMLCONCAT, XMLELEMENT, XMLEXISTS, XMLFOREST, XMLNAMESPACES, XMLPARSE, XMLPI, XMLQUERY, XMLROOT, XMLSERIALIZE, XMLTEXT, XMLVALIDATE, YEAR.

Notes: