Edit C:\Program Files (x86)\PostgreSQL\9.5\data\base\16394\12204
4l ?? ?` ??^ h?d 0?h ?d ??f ??b X?^ ?j ?p ??? @?? ? ??? P?? ?z ?n ??j `?r ?v ??r ??t h?p 0?p ?l ??t x?x 8?t ?v ??r ??p (?? ?? ??n @?? ?? ??? 0?? ??? x?? 8?r ? ??? @?? ??"P?? ?? ??? P?? ?? ??? @?? ? ??` p?? (?? ??? ??| P?? ?? ??? (?? ?? x?? ?? ??? X?? ??? ??? ?? ??? P?? ??? ??? ?? ??? H?? ?? `?? ?? ??x `?? ?? ??? ???? ??j 8?? ??? ??? 0?? ?? p?? ?? ?? 7 _ _ E081#Basic Privileges08%WITH GRANT OPTION YES7 ^ _ E081#Basic Privileges07SREFERENCES privilege at the column level YES 7 ] _ E081#Basic Privileges06QREFERENCES privilege at the table level YES 7 \ _ E081#Basic Privileges05KUPDATE privilege at the column level YES 7 [ _ E081#Basic Privileges04IUPDATE privilege at the table level YES 7 Z _ E081#Basic Privileges03IINSERT privilege at the table level YES 7 Y _ E081#Basic Privileges02#DELETE privilege YES 7 X _ E081#Basic Privileges01#SELECT privilege YES 7 W _ E081#Basic Privileges YES 7 V _ E0711Basic query expressions06=Table operators in subqueries YES 7 U _ E0711Basic query expressions05?Columns combined via table operators need not have exactly the same data type YES 7 T _ E0711Basic query expressions03?EXCEPT DISTINCT table operator YES 7 S _ E0711Basic query expressions023UNION ALL table operator YES 7 R _ E0711Basic query expressions01=UNION DISTINCT table operator YES 7 Q _ E0711Basic query expressions YES 7 P _ E061OBasic predicates and search conditions14#Search condition YES 7 O _ E061OBasic predicates and search conditions13-Correlated subqueries YES 7 N _ E061OBasic predicates and search conditions12]Subqueries in quantified comparison predicate YES 7 M _ E061OBasic predicates and search conditions117Subqueries in IN predicate YES 7 L _ E061OBasic predicates and search conditions09GSubqueries in comparison predicate YES 7 K _ E061OBasic predicates and search conditions08#EXISTS predicate YES 7 J _ E061OBasic predicates and search conditions07AQuantified comparison predicate YES 7 I _ E061OBasic predicates and search conditions06 NULL predicate YES 7 H _ E061OBasic predicates and search conditions05;LIKE predicate ESCAPE clause YES 7 G _ E061OBasic predicates and search conditions04 LIKE predicate YES 7 F _ E061OBasic predicates and search conditions03CIN predicate with list of values YES 7 E _ E061OBasic predicates and search conditions02%BETWEEN predicate YES 7 D _ E061OBasic predicates and search conditions01+Comparison predicate YES 7 C _ E061OBasic predicates and search conditions YES 7 B _ E0515Basic query specification09ERename columns in the FROM clause YES 7 A _ E0515Basic query specification08KCorrelation names in the FROM clause YES 7 @ _ E0515Basic query specification077Qualified * in select list YES 7 ? _ E0515Basic query specification06 HAVING clause YES 7 > _ E0515Basic query specification05CSelect list items can be renamed YES7 = _ E0515Basic query specification04eGROUP BY can contain columns not in <select list> YES 7 < _ E0515Basic query specification02!GROUP BY clause YES 7 ; _ E0515Basic query specification01!SELECT DISTINCT YES 7 : _ E0515Basic query specification YES 7 9 _ E031Identifiers03)Trailing underscore YES 7 8 _ E031Identifiers02/Lower case identifiers YES7 7 _ E031Identifiers01-Delimited identifiers YES 7 6 _ E031Identifiers YES7 5 _ E021/Character string types12+Character comparison YES 7 4 _ E021/Character string types11%POSITION function YES 7 3 _ E021/Character string types10eImplicit casting among the character string types YES 7 2 _ E021/Character string types09 TRIM function YES 7 1 _ E021/Character string types085UPPER and LOWER functions YES 7 0 _ E021/Character string types071Character concatenation YES 7 / _ E021/Character string types06'SUBSTRING function YES 7 . _ E021/Character string types05-OCTET_LENGTH function YES 7 - _ E021/Character string types045CHARACTER_LENGTH function YESytrims trailing spaces from CHARACTER values before counting 7 , _ E021/Character string types03'Character literals YES 7 + _ E021/Character string types029CHARACTER VARYING data type YES7 * _ E021/Character string types01)CHARACTER data type YES7 ) _ E021+Character data types YES 7 ( _ E011'Numeric data types06]Implicit casting among the numeric data types YES 7 ' _ E011'Numeric data types05'Numeric comparison YES 7 & _ E011'Numeric data types04+Arithmetic operators YES 7 % _ E011'Numeric data types03?DECIMAL and NUMERIC data types YES 7 $ _ E011'Numeric data types02[REAL, DOUBLE PRECISION, and FLOAT data types YES 7 # _ E011'Numeric data types01AINTEGER and SMALLINT data types YES7 " _ E011'Numeric data types YES 7 ! _ B221eRoutine language Ada: VARCHAR and NUMERIC supportNO 7 _ B211cModule language Ada: VARCHAR and NUMERIC supportNO 7 _ B128+Routine language SQLNO7 _ B127-Routine language PL/INO 7 _ B1261Routine language PascalNO 7 _ B125/Routine language MUMPSNO 7 _ B1243Routine language FortranNO 7 _ B123/Routine language COBOLNO 7 _ B122'Routine language CNO 7 _ B121+Routine language AdaNO7 _ B117+Module language PL/INO7 _ B116/Module language PascalNO 7 _ B115-Module language MUMPSNO 7 _ B1141Module language FortranNO 7 _ B113-Module language COBOLNO 7 _ B112%Module language CNO 7 _ B111)Module language AdaNO 7 _ B0515Enhanced execution rightsNO 7 _ B041eExtensions to embedded SQL exception declarationsNO 7 _ B035=Non-extended descriptor namesNO 7 _ B034WDynamic specification of cursor attributesNO 7 _ B033OUntyped SQL-invoked function argumentsNO 7 _ B032+Extended dynamic SQL017<describe input statement>NO 7 _ B032+Extended dynamic SQLNO7 _ B031%Basic dynamic SQLNO 7 _ B021Direct SQL YES 7 _ B017 Embedded PL/INO 7 _ B016!Embedded PascalNO 7 _ B015 Embedded MUMPSNO 7 _ B014#Embedded FortranNO 7 _ B013 Embedded COBOLNO 7 _ B012Embedded C YES 7 _ B011Embedded AdaNO ?tl |? ??? p?? 8?d ?n ??r ??n P?n ?n ?? ??? H?x ? ??? H?? ?? ?r x?? ?? ??? `?? ?? ??? `?? ?? ??? `?? ?? ?? `?? ?? @?t? ??? (?? ??? x?p (?? ?? ??? ???8?? ? ??j x?f 8?z ? ??? H?? ??? ??? 8?? ?| ??? (?? ?? p?? ?? ??? 8?? ?t ??? h?| ?? p?? ????n 8?? ??? ??? X?? ?? x? ?? ?p X?? ??8?X??? ?? ?? ??? 8?? ??? ??n h?? (?| ?? ??\ 7 Y _ F521AssertionsNO 7 X _ F111SIsolation levels other than SERIALIZABLE YES 7 W _ F0815UNION and EXCEPT in views YES 7 V _ F054OTIMESTAMP in DATE type precedence listNO 7 U _ F053'OVERLAPS predicate YES 7 T _ F052EIntervals and datetime arithmetic YES 7 S _ F051)Basic date and time08 LOCALTIMESTAMP YES7 R _ F051)Basic date and time07LOCALTIME YES 7 Q _ F051)Basic date and time06CURRENT_DATE YES 7 P _ F051)Basic date and time05?Explicit CAST between datetime types and character string types YES 7 O _ F051)Basic date and time04{Comparison predicate on DATE, TIME, and TIMESTAMP data types YES 7 N _ F051)Basic date and time03?TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES 7 M _ F051)Basic date and time02?TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES 7 L _ F051)Basic date and time01gDATE data type (including support of DATE literal) YES 7 K _ F051)Basic date and time YES7 J _ F041'Basic joined table08yAll comparison operators are supported (rather than just =) YES 7 I _ F041'Basic joined table07?The inner table in a left or right outer join can also be used in an inner join YES7 H _ F041'Basic joined table055Outer joins can be nested YES 7 G _ F041'Basic joined table04#RIGHT OUTER JOIN YES 7 F _ F041'Basic joined table03!LEFT OUTER JOIN YES7 E _ F041'Basic joined table02 INNER keyword YES 7 D _ F041'Basic joined table01gInner join (but not necessarily the INNER keyword) YES 7 C _ F041'Basic joined table YES 7 B _ F0345Extended REVOKE statement03?REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES 7 A _ F0345Extended REVOKE statement02UREVOKE statement: GRANT OPTION FOR clause YES 7 @ _ F0345Extended REVOKE statement01?REVOKE statement performed by other than the owner of a schema object YES 7 ? _ F0345Extended REVOKE statement YES 7 > _ F033UALTER TABLE statement: DROP COLUMN clause YES 7 = _ F032-CASCADE drop behavior YES 7 < _ F0315Basic schema manipulation19EREVOKE statement: RESTRICT clause YES 7 ; _ F0315Basic schema manipulation16KDROP VIEW statement: RESTRICT clause YES 7 : _ F0315Basic schema manipulation13MDROP TABLE statement: RESTRICT clause YES 7 9 _ F0315Basic schema manipulation04SALTER TABLE statement: ADD COLUMN clause YES7 8 _ F0315Basic schema manipulation03!GRANT statement YES 7 7 _ F0315Basic schema manipulation02-CREATE VIEW statement YES 7 6 _ F0315Basic schema manipulation01qCREATE TABLE statement to create persistent base tables YES 7 5 _ F0315Basic schema manipulation YES 7 4 _ F0213Basic information schema06/CHECK_CONSTRAINTS view YES 7 3 _ F0213Basic information schema05;REFERENTIAL_CONSTRAINTS view YES 7 2 _ F0213Basic information schema04/TABLE_CONSTRAINTS view YES 7 1 _ F0213Basic information schema03VIEWS view YES 7 0 _ F0213Basic information schema02TABLES view YES 7 / _ F0213Basic information schema01COLUMNS view YES 7 . _ F0213Basic information schema YES 7 - _ E182!Module languageNO 7 , _ E171#SQLSTATE support YES 7 + _ E161QSQL comments using leading double minus YES 7 * _ E153EUpdatable queries with subqueries YES 7 ) _ E152ABasic SET TRANSACTION statement02ySET TRANSACTION statement: READ ONLY and READ WRITE clauses YES 7 ( _ E152ABasic SET TRANSACTION statement01SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES 7 ' _ E152ABasic SET TRANSACTION statement YES 7 & _ E151)Transaction support02'ROLLBACK statement YES 7 % _ E151)Transaction support01#COMMIT statement YES 7 $ _ E151)Transaction support YES7 # _ E1419Basic integrity constraints10kNames in a foreign key can be specified in any order YES 7 " _ E1419Basic integrity constraints08CNOT NULL inferred on PRIMARY KEY YES 7 ! _ E1419Basic integrity constraints07!Column defaults YES 7 _ E1419Basic integrity constraints06%CHECK constraints YES 7 _ E1419Basic integrity constraints04?Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES 7 _ E1419Basic integrity constraints031PRIMARY KEY constraints YES 7 _ E1419Basic integrity constraints02OUNIQUE constraints of NOT NULL columns YES7 _ E1419Basic integrity constraints01+NOT NULL constraints YES 7 _ E1419Basic integrity constraints YES7 _ E131[Null value support (nulls in lieu of values) YES 7 _ E121+Basic cursor support17%WITH HOLD cursors YES 7 _ E121+Basic cursor support10=FETCH statement implicit NEXT YES7 _ E121+Basic cursor support08!CLOSE statement YES 7 _ E121+Basic cursor support079Positioned DELETE statement YES 7 _ E121+Basic cursor support069Positioned UPDATE statement YES 7 _ E121+Basic cursor support04 OPEN statement YES 7 _ E121+Basic cursor support03KValue expressions in ORDER BY clause YES 7 _ E121+Basic cursor support02YORDER BY columns need not be in select list YES 7 _ E121+Basic cursor support01 DECLARE CURSOR YES 7 _ E121+Basic cursor support YES 7 _ E1119Single row SELECT statement YES7 _ E1011Basic data manipulation045Searched DELETE statement YES 7 _ E1011Basic data manipulation035Searched UPDATE statement YES 7 _ E1011Basic data manipulation01#INSERT statement YES 7 _ E1011Basic data manipulation YES 7 _ E091 Set functions07)DISTINCT quantifier YES 7 _ E091 Set functions06 ALL quantifier YES 7 _ E091 Set functions05 SUM YES 7 _ E091 Set functions04 MIN YES 7 _ E091 Set functions03 MAX YES 7 _ E091 Set functions02 COUNT YES 7 _ E091 Set functions01 AVG YES 7 _ E091 Set functions YES 7 _ E081#Basic Privileges10%EXECUTE privilege YES7 _ E081#Basic Privileges09!USAGE privilege YES ?l ?? ??? ?? ??? p?? ?? ??? P?? ?f ??n X??? x?? ?? ??? @?| ?v ??~ ??z H?d ? ??l h?? 0?j ??? ??? @?? ?f ?h ??? @?? ?x ??| ??z (?? ? ??l x?h 0?? ?z ??? 0?? ?| ??~ `?? ?? ??? @?? ? ??? H?x ?? ?n x?? @?n ? ??? ?? ??? h?v (?~ ??? ??? @?? ?j ??? ??? 8?? ?t ??? `?? ?? ??? ??z ?? ??n ??? 8?? ? ??? H?? ??? ??? P?? ?? ??x ??p H?v ?x ?t x?? 0?? ?? ??? (?? ??? ??? ?? ?? 7 b _ F502=Enhanced documentation tables03%SQL_PACKAGES view YES 7 a _ F502=Enhanced documentation tables02;SQL_IMPLEMENTATION_INFO view YES7 ` _ F502=Enhanced documentation tables013SQL_SIZING_PROFILES view YES 7 _ _ F502=Enhanced documentation tables YES 7 ^ _ F501?Features and conformance views03'SQL_LANGUAGES view YES 7 ] _ F501?Features and conformance views02!SQL_SIZING view YES 7 \ _ F501?Features and conformance views01%SQL_FEATURES view YES 7 [ _ F501?Features and conformance views YES 7 Z _ F492MOptional table constraint enforcementNO 7 Y _ F491-Constraint management YES 7 X _ F4811Expanded NULL predicate YES 7 W _ F471/Scalar subquery values YES 7 V _ F461+Named character setsNO7 U _ F4513Character set definitionNO 7 T _ F442SMixed column references in set functions YES 7 S _ F441=Extended set function support YES 7 R _ F431;Read-only scrollable cursors06 FETCH RELATIVE YES 7 Q _ F431;Read-only scrollable cursors05 FETCH ABSOLUTE YES 7 P _ F431;Read-only scrollable cursors04FETCH PRIOR YES 7 O _ F431;Read-only scrollable cursors03FETCH LAST YES 7 N _ F431;Read-only scrollable cursors02FETCH FIRST YES 7 M _ F431;Read-only scrollable cursors013FETCH with explicit NEXT YES 7 L _ F431;Read-only scrollable cursors YES 7 K _ F421'National character YES 7 J _ F4111Time zone specification YES[differences regarding literal interpretation7 I _ F4035Partitioned joined tablesNO 7 H _ F402gNamed column joins for LOBs, arrays, and multisets YES 7 G _ F401-Extended joined table04CROSS JOIN YES 7 F _ F401-Extended joined table02!FULL OUTER JOIN YES 7 E _ F401-Extended joined table01NATURAL JOIN YES7 D _ F401-Extended joined table YES 7 C _ F394GOptional normal form specificationNO 7 B _ F3939Unicode escapes in literals YES7 A _ F392?Unicode escapes in identifiers YES 7 @ _ F391#Long identifiers YES 7 ? _ F386MSet identity column generation clauseNO 7 > _ F385SDrop column generation expression clauseNO 7 = _ F384=Drop identity property clauseNO 7 < _ F3837Set column not null clause YES 7 ; _ F382/Alter column data type YES 7 : _ F381;Extended schema manipulation03]ALTER TABLE statement: DROP CONSTRAINT clause YES7 9 _ F381;Extended schema manipulation02[ALTER TABLE statement: ADD CONSTRAINT clause YES 7 8 _ F381;Extended schema manipulation01WALTER TABLE statement: ALTER COLUMN clause YES 7 7 _ F381;Extended schema manipulation YES 7 6 _ F361'Subprogram support YES 7 5 _ F341Usage tablesNO5no ROUTINE_*_USAGE tables 7 4 _ F321'User authorization YES 7 3 _ F314GMERGE statement with DELETE branchNO 7 2 _ F3133Enhanced MERGE statementNO 7 1 _ F312!MERGE statementNOUconsider INSERT ... ON CONFLICT DO UPDATE 7 0 _ F3119Schema definition statement05!GRANT statement YES 7 / _ F3119Schema definition statement04?CREATE VIEW: WITH CHECK OPTION YES7 . _ F3119Schema definition statement03CREATE VIEW YES 7 - _ F3119Schema definition statement02QCREATE TABLE for persistent base tables YES 7 , _ F3119Schema definition statement01 CREATE SCHEMA YES 7 + _ F3119Schema definition statementNO 7 * _ F3045EXCEPT ALL table operator YES 7 ) _ F3023INTERSECT table operator02;INTERSECT ALL table operator YES 7 ( _ F3023INTERSECT table operator01EINTERSECT DISTINCT table operator YES7 ' _ F3023INTERSECT table operator YES 7 & _ F301GCORRESPONDING in query expressionsNO 7 % _ F291#UNIQUE predicateNO 7 $ _ F281%LIKE enhancements YES 7 # _ F2719Compound character literals YES7 " _ F263kComma-separated predicates in simple CASE expressionNO7 ! _ F2623Extended CASE expression YES 7 _ F261!CASE expression04COALESCE YES 7 _ F261!CASE expression03NULLIF YES 7 _ F261!CASE expression02 Searched CASE YES 7 _ F261!CASE expression01Simple CASE YES 7 _ F261!CASE expression YES 7 _ F251 Domain support YES 7 _ F231#Privilege tables03-USAGE_PRIVILEGES view YES 7 _ F231#Privilege tables02/COLUMN_PRIVILEGES view YES 7 _ F231#Privilege tables01-TABLE_PRIVILEGES view YES 7 _ F231#Privilege tables YES 7 _ F222QINSERT statement: DEFAULT VALUES clause YES 7 _ F221%Explicit defaults YES 7 _ F202_TRUNCATE TABLE: identity column restart optionNO 7 _ F201 CAST function YES 7 _ F2003TRUNCATE TABLE statement YES 7 _ F1917Referential delete actions YES 7 _ F1811Multiple module supportNO 7 _ F1715Multiple schemas per user YES 7 _ F131'Grouped operations05?Single row SELECT with GROUP BY and HAVING clauses and grouped views YES 7 _ F131'Grouped operations04}Subqueries with GROUP BY and HAVING clauses and grouped views YES 7 _ F131'Grouped operations03mSet functions supported in queries with grouped views YES 7 _ F131'Grouped operations02qMultiple tables supported in queries with grouped views YES7 _ F131'Grouped operations01?WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES 7 _ F131'Grouped operations YES 7 _ F123!All diagnosticsNO 7 _ F122AEnhanced diagnostics managementNO 7 _ F121;Basic diagnostics management02gSET TRANSACTION statement: DIAGNOSTICS SIZE clauseNO 7 _ F121;Basic diagnostics management015GET DIAGNOSTICS statementNO 7 _ F121;Basic diagnostics managementNO7 _ F111SIsolation levels other than SERIALIZABLE03AREPEATABLE READ isolation level YES 7 _ F111SIsolation levels other than SERIALIZABLE02?READ COMMITTED isolation level YES 7 _ F111SIsolation levels other than SERIALIZABLE01CREAD UNCOMMITTED isolation level YES ??l ?? ?j ??~ H?v ?l ?f ??r X?~ ?x ??d ??? H?? ? ??~ `?? (?n ??? ??~ h?b ?? ?z ??? @?x ?n ?h ??f X?t ?? ??p ??l p?d 8?j ?t ??l h?? ?? ?p ??z X?v ?x ?x ??? 8?? ??? ??? H?? ? ??? 8?? ? ??? H?? ? ??? @?? ? ??? P?? ?? ?n ??? @?t ?z ??t x?? (?? ?~ ??r h?x ?? ??? ??Z @?? ? ??? @?? ? ??z x?? 8?t ?x ?\ ??| P?d ?j ?? ??? 0?? ?? ??? @?? ?x ?d ??j X?n ?z ?t ??p `?t ?? ?? ??z X?v ?? ?h ??? @?? ?r ?\ ??? @?? ? 7 o _ T022kAdvanced support for BINARY and VARBINARY data typesNO7 n _ T021ABINARY and VARBINARY data typesNO 7 m _ T011ATimestamp in Information SchemaNO 7 l _ S404TRIM_ARRAYNO 7 k _ S403-ARRAY_MAX_CARDINALITYNO 7 j _ S402ODistinct types based on distinct typesNO 7 i _ S401IDistinct types based on array typesNO 7 h _ S301!Enhanced UNNEST YES 7 g _ S291AUnique constraint on entire rowNO 7 f _ S2811Nested collection typesNO 7 e _ S2755Advanced multiset supportNO 7 d _ S274;Multisets of reference typesNO7 c _ S272AMultisets of user-defined typesNO 7 b _ S271/Basic multiset supportNO 7 a _ S261+Specific type methodNO7 ` _ S251/User-defined orderingsNO 7 _ _ S2425Alter transform statementNO 7 ^ _ S241)Transform functionsNO 7 ] _ S233%Multiset locatorsNO 7 \ _ S232 Array locatorsNO 7 [ _ S2313Structured type locatorsNO 7 Z _ S2119User-defined cast functions YES7 Y _ S202ESQL-invoked routines on multisetsNO 7 X _ S201?SQL-invoked routines on arrays02EArray as result type of functions YES 7 W _ S201?SQL-invoked routines on arrays01#Array parameters YES 7 V _ S201?SQL-invoked routines on arrays YES 7 U _ S162CSubtype treatment for referencesNO 7 T _ S161%Subtype treatmentNO 7 S _ S151 Type predicateNO 7 R _ S1115ONLY in query expressions YES 7 Q _ S098ARRAY_AGG YES 7 P _ S0973Array element assignmentNO 7 O _ S096-Optional array bounds YES 7 N _ S0959Array constructors by query YES7 M _ S0945Arrays of reference typesNO 7 L _ S092;Arrays of user-defined types YES 7 K _ S091)Basic array support03%Array expressionsNO 7 J _ S091)Basic array support023Arrays of distinct typesNO 7 I _ S091)Basic array support01=Arrays of built-in data typesNO 7 H _ S091)Basic array supportNO)partially supported 7 G _ S081SubtablesNO 7 F _ S071_SQL paths in function and type name resolution YES 7 E _ S051+Create table of typeNO)partially supported 7 D _ S0433Enhanced reference typesNO 7 C _ S041-Basic reference typesNO 7 B _ S0289Permutable UDT options listNO 7 A _ S027MCreate method by specific method nameNO 7 @ _ S026ESelf-referencing structured typesNO 7 ? _ S025/Final structured typesNO 7 > _ S0245Enhanced structured typesNO 7 = _ S023/Basic structured typesNO 7 < _ S011)Distinct data types011USER_DEFINED_TYPES viewNO7 ; _ S011)Distinct data typesNO 7 : _ F867KFETCH FIRST clause: WITH TIES optionNO7 9 _ F866GFETCH FIRST clause: PERCENT optionNO 7 8 _ F865[<offset row count> in <result offset clause> YES 7 7 _ F864UTop-level <result offset clause> in views YES 7 6 _ F863iNested <result offset clause> in <query expression> YES7 5 _ F862K<result offset clause> in subqueries YES 7 4 _ F861oTop-level <result offset clause> in <query expression> YES 7 3 _ F860a<fetch first row count> in <fetch first clause> YES 7 2 _ F859QTop-level <fetch first clause> in views YES 7 1 _ F858G<fetch first clause> in subqueries YES 7 0 _ F857kTop-level <fetch first clause> in <query expression> YES 7 / _ F856eNested <fetch first clause> in <query expression> YES 7 . _ F855_Nested <order by clause> in <query expression> YES 7 - _ F852KTop-level <order by clause> in views YES 7 , _ F851A<order by clause> in subqueries YES 7 + _ F850eTop-level <order by clause> in <query expression> YES 7 * _ F847ANonconstant regular expressionsNO 7 ) _ F846]Octet support in regular expression operatorsNO 7 ( _ F8453TRANSLATE_REGEX functionNO 7 ' _ F8443SUBSTRING_REGEX functionNO 7 & _ F8431POSITION_REGEX functionNO 7 % _ F8425OCCURENCES_REGEX functionNO 7 $ _ F841+LIKE_REGEX predicateNO7 # _ F831'Full cursor update025Updatable ordered cursorsNO 7 " _ F831'Full cursor update01;Updatable scrollable cursorsNO 7 ! _ F831'Full cursor updateNO 7 _ F821/Local table referencesNO 7 _ F813%Extended flaggingNO 7 _ F812 Basic flaggingNO 7 _ F801%Full set function YES 7 _ F791)Insensitive cursors YES7 _ F7819Self-referencing operations YES7 _ F771-Connection management YES 7 _ F763 CURRENT_SCHEMA YES 7 _ F762!CURRENT_CATALOG YES 7 _ F761'Session management YES 7 _ F7511View CHECK enhancements YES 7 _ F7411Referential MATCH typesNO+no partial match yet 7 _ F7313INSERT column privileges YES 7 _ F721/Deferrable constraintsNO;foreign and unique keys only 7 _ F711ALTER domain YES 7 _ F7017Referential update actions YES 7 _ F696KAdditional translation documentationNO7 _ F695)Translation supportNO 7 _ F693SSQL-session and client module collationsNO 7 _ F6927Extended collation support YES 7 _ F690%Collation support YES;but no character set support 7 _ F672ARetrospective check constraints YES 7 _ F671)Subqueries in CHECKNO-intentionally omitted 7 _ F661 Simple tables YES 7 _ F6511Catalog name qualifiers YES 7 _ F6417Row and table constructors YES 7 _ F611+Indicator data types YES 7 _ F591 Derived tables YES 7 _ F571%Truth value tests YES 7 _ F561/Full value expressions YES 7 _ F5557Enhanced seconds precision YES 7 _ F531#Temporary tables YES ?l ?? ??v ??z H?l ?~ ??? h?? ?"p?? ?? ?? ??` h?` 8?Z ?z ??? x?^ @?j ? ??? X?? ?? ?h ??? X?l ?n ?? ??? @?? ? ??h ??j @?| ? ??? X?v ?? ?? x?? 8?x ?? h?? ?? ??? (?(??P?? ??vP?? ?p ??l ??? P?? ?p ?^ ??? P?? ?? ??? ??j @?| ?? X?? ?? ??? `?? ?? ??? x?? (?? ??? ??? `?f 0?` ? ??? @?? ? ??? `?? (?j ?t ??? h?x 0?f ??t ??? X?| ?j ?l ??? ???? ??j 0?? ?? ??? 8?? ?v ??~ h?? 8?Z ?f ??v 7 g _ T615/LEAD and LAG functions YES 7 f _ T614 NTILE function YES 7 e _ T613Sampling YES 7 d _ T6123Advanced OLAP operationsNO+some forms supported7 c _ T6117Elementary OLAP operations YES 7 b _ T6011Local cursor referencesNO 7 a _ T591YUNIQUE constraints of possibly null columns YES7 ` _ T581MRegular expression substring function YES 7 _ _ T572eMultiset-returning external SQL-invoked functionsNO 7 ^ _ T571_Array-returning external SQL-invoked functionsNO 7 ] _ T561%Holdable locatorsNO 7 \ _ T551MOptional key words for default syntax YES 7 [ _ T522wDefault values for IN parameters of SQL-invoked proceduresNOasupported except DEFAULT key word in invocation 7 Z _ T521ENamed arguments in CALL statementNO 7 Y _ T511'Transaction countsNO 7 X _ T502%Period predicatesNO 7 W _ T5015Enhanced EXISTS predicate YES 7 V _ T495GCombined data change and retrievalNO#different syntax 7 U _ T491-LATERAL derived table YES 7 T _ T472!DESCRIBE CURSORNO 7 S _ T4713Result sets return valueNO 7 R _ T4619Symmetric BETWEEN predicate YES7 Q _ T441-ABS and MOD functions YES 7 P _ T434%GROUP BY DISTINCTNO 7 O _ T433AMultiargument GROUPING function YES 7 N _ T432MNested and concatenated GROUPING SETS YES 7 M _ T431?Extended grouping capabilities YES 7 L _ T351UBracketed SQL comments (/*...*/ comments) YES 7 K _ T341iOverloading of SQL-invoked functions and procedures YES7 J _ T332 Extended rolesNO#mostly supported 7 I _ T331Basic roles YES7 H _ T326!Table functionsNO 7 G _ T325GQualified SQL parameter references YES 7 F _ T324GExplicit security for SQL routinesNO 7 E _ T323QExplicit security for external routines YES 7 D _ T322=Declared data type attributesNO 7 C _ T3217Basic SQL-invoked routines07!PARAMETERS view YES7 B _ T3217Basic SQL-invoked routines06 ROUTINES view YES 7 A _ T3217Basic SQL-invoked routines05#RETURN statementNO7 @ _ T3217Basic SQL-invoked routines04 CALL statementNO 7 ? _ T3217Basic SQL-invoked routines03)Function invocation YES 7 > _ T3217Basic SQL-invoked routines02gUser-defined stored procedures with no overloadingNO 7 = _ T3217Basic SQL-invoked routines01WUser-defined functions with no overloading YES 7 < _ T3217Basic SQL-invoked routinesNO 7 ; _ T312#OVERLAY function YES 7 : _ T3011Functional dependenciesNO)partially supported 7 9 _ T285=Enhanced derived column namesNO 7 8 _ T281SSELECT privilege with column granularity YES 7 7 _ T272=Enhanced savepoint managementNO 7 6 _ T271Savepoints YES 7 5 _ T261+Chained transactionsNO7 4 _ T251QSET TRANSACTION statement: LOCAL optionNO 7 3 _ T2419START TRANSACTION statement YES7 2 _ T231%Sensitive cursors YES 7 1 _ T213)INSTEAD OF triggers YES7 0 _ T2129Enhanced trigger capability YES7 / _ T2113Basic trigger capability08?Multiple triggers for the same event are executed in the order in which they were created in the catalogNO-intentionally omitted 7 . _ T2113Basic trigger capability07%TRIGGER privilege YES7 - _ T2113Basic trigger capability06?Support for run-time rules for the interaction of triggers and constraintsNO7 , _ T2113Basic trigger capability05?Ability to specify a search condition that must be true before the trigger is invoked YES 7 + _ T2113Basic trigger capability04-FOR EACH ROW triggers YES 7 * _ T2113Basic trigger capability03 AFTER triggers YES 7 ) _ T2113Basic trigger capability02!BEFORE triggers YES 7 ( _ T2113Basic trigger capability01?Triggers activated on UPDATE, INSERT, or DELETE of one base table YES7 ' _ T2113Basic trigger capabilityNO 7 & _ T201eComparable data types for referential constraints YES 7 % _ T1919Referential action RESTRICT YES7 $ _ T181?Application-time period tablesNO 7 # _ T1801System-versioned tablesNO 7 " _ T178SIdentity columns: simple restart optionNO 7 ! _ T177eSequence generator support: simple restart optionNO 7 _ T1767Sequence generator supportNO 7 _ T175%Generated columnsNO 7 _ T174#Identity columnsNO 7 _ T173SExtended LIKE clause in table definition YES 7 _ T172OAS subquery clause in table definition YES 7 _ T171ALIKE clause in table definition YES 7 _ T152CDISTINCT predicate with negation YES 7 _ T151'DISTINCT predicate YES 7 _ T141%SIMILAR predicate YES 7 _ T1329Recursive query in subquery YES7 _ T131!Recursive query YES 7 _ T122OWITH (excluding RECURSIVE) in subquery YES 7 _ T121_WITH (excluding RECURSIVE) in query expression YES 7 _ T111KUpdatable joins, unions, and columnsNO7 _ T101GEnhanced nullability determinationNO 7 _ T071#BIGINT data type YES 7 _ T061UCS supportNO 7 _ T053UExplicit aliases for all-fields referenceNO 7 _ T0525MAX and MIN for row typesNO 7 _ T051Row typesNO 7 _ T044Multiplier PNO7 _ T043Multiplier TNO7 _ T042?Extended LOB data type supportNO 7 _ T0419Basic LOB data type support055LOB locator: non-holdableNO 7 _ T0419Basic LOB data type support04AConcatenation of LOB data typesNO7 _ T0419Basic LOB data type support03?POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data typesNO 7 _ T0419Basic LOB data type support02 CLOB data typeNO 7 _ T0419Basic LOB data type support01 BLOB data typeNO 7 _ T0419Basic LOB data type supportNO 7 _ T031%BOOLEAN data type YES 7 _ T0245Spaces in binary literalsNO 7 _ T0231Compound binary literalNO ??l ?? ??? `?? ?? ??v ??? @?~ ? ??? @?? ? ??? P?? ?? ?Z ??r X?| ?? ?t ??p X?f ?? ??? ??j P?f ?n ?r ??f h?p 0?l ?? x?? ?? ?? p?? ?? ??? x?? (?? ?Z ??n ??r @?| ?t ?l ??t X?\ (?V ?^ ?^ ??\ h?V (?x ?^ ?T ??V `?p ?? ?? ??? 0?? ??? ??? H?? ? ??? P?v ?? ??? h?? ?? ??? p?? ?? ??? `?? ?? ??? X?? ?? ?j ??p 0?? ?? p?? ?? ??? x?? 8?r ? ??? X?? ?? ??? x?? ?? ?? ??? H?v ?r ?Z ??? (?? ?? ??? 0?? ?? 7 j _ X113oHost language support for XML: STRIP WHITESPACE optionNO 7 i _ X112YHost language support for XML: BLOB mappingNO 7 h _ X111YHost language support for XML: CLOB mappingNO 7 g _ X110_Host language support for XML: VARCHAR mappingNO 7 f _ X101_Host language support for XML: DOCUMENT optionNO 7 e _ X100]Host language support for XML: CONTENT optionNO 7 d _ X096XMLExistsNO 7 c _ X091-XML content predicateNO 7 b _ X090/XML document predicate YES 7 a _ X086OXML namespace declarations in XMLTableNO 7 ` _ X085=Predefined namespace prefixesNO 7 _ _ X084eXML namespace declarations in compound statementsNO 7 ^ _ X083EXML namespace declarations in DDLNO 7 ] _ X082EXML namespace declarations in DMLNO 7 \ _ X081OQuery-level XML namespace declarationsNO 7 [ _ X080;Namespaces in XML publishingNO7 Z _ X078OXMLSerialize: explicit XML declarationNO 7 Y _ X077OXMLSerialize: explicit ENCODING optionNO 7 X _ X076-XMLSerialize: VERSIONNO 7 W _ X075CXMLSerialize: BLOB serializationNO 7 V _ X074kXMLSerialize: BLOB serialization and DOCUMENT optionNO7 U _ X073iXMLSerialize: BLOB serialization and CONTENT optionNO 7 T _ X072[XMLSerialize: character string serialization YES 7 S _ X071?XMLSerialize: character string serialization and DOCUMENT option YES 7 R _ X070?XMLSerialize: character string serialization and CONTENT option YES 7 Q _ X069+XMLSerialize: INDENTNO7 P _ X068%XMLSerialize: BOMNO 7 O _ X066SXMLParse: BLOB input and DOCUMENT optionNO 7 N _ X065QXMLParse: BLOB input and CONTENT optionNO 7 M _ X061kXMLParse: character string input and DOCUMENT option YES 7 L _ X060iXMLParse: character string input and CONTENT option YES7 K _ X059oAdvanced table mapping: hex encoding of binary strings YES 7 J _ X058uAdvanced table mapping: base64 encoding of binary strings YES 7 I _ X057SAdvanced table mapping: metadata mapping YES 7 H _ X056KAdvanced table mapping: data mapping YES 7 G _ X055]Advanced table mapping: with target namespace YES 7 F _ X054SAdvanced table mapping: table as element YES 7 E _ X053QAdvanced table mapping: table as forest YES 7 D _ X052IAdvanced table mapping: null as nil YES7 C _ X051KAdvanced table mapping: nulls absent YES 7 B _ X050/Advanced table mapping YES 7 A _ X049iBasic table mapping: hex encoding of binary strings YES7 @ _ X048oBasic table mapping: base64 encoding of binary strings YES 7 ? _ X047MBasic table mapping: metadata mapping YES 7 > _ X046EBasic table mapping: data mapping YES 7 = _ X045WBasic table mapping: with target namespace YES 7 < _ X044MBasic table mapping: table as element YES 7 ; _ X043KBasic table mapping: table as forest YES 7 : _ X042CBasic table mapping: null as nil YES 7 9 _ X041EBasic table mapping: nulls absent YES 7 8 _ X040)Basic table mapping YES7 7 _ X038XMLTextNO 7 6 _ X037 XMLPI YES 7 5 _ X036XMLComment YES 7 4 _ X0351XMLAgg: ORDER BY option YES 7 3 _ X034XMLAgg YES 7 2 _ X032XMLForest YES 7 1 _ X031XMLElement YES 7 0 _ X030XMLDocumentNO 7 / _ X025XMLCastNO 7 . _ X020XMLConcat YES 7 - _ X016-Persistent XML values YES 7 , _ X015'Fields of XML typeNO 7 + _ X014/Attributes of XML typeNO 7 * _ X0137Distinct types of XML typeNO 7 ) _ X012-Multisets of XML typeNO 7 ( _ X011'Arrays of XML type YES 7 ' _ X010XML type YES 7 & _ M031MForeign data wrapper general routinesNO 7 % _ M030ASQL-server foreign data supportNO 7 $ _ M024aForeign data wrapper interface routines in PL/INO 7 # _ M023eForeign data wrapper interface routines in PascalNO 7 " _ M022cForeign data wrapper interface routines in MUMPSNO 7 ! _ M021gForeign data wrapper interface routines in FortranNO 7 _ M020cForeign data wrapper interface routines in COBOLNO 7 _ M019[Foreign data wrapper interface routines in CNO different API 7 _ M018_Foreign data wrapper interface routines in AdaNO 7 _ M017'Datalinks via PL/INO 7 _ M016+Datalinks via PascalNO7 _ M015!Datalinks via MNO 7 _ M014-Datalinks via FortranNO 7 _ M013)Datalinks via COBOLNO 7 _ M012!Datalinks via CNO 7 _ M011%Datalinks via AdaNO 7 _ M010;Foreign data wrapper supportNO different API 7 _ M009GGetOpts and GetStatistics routinesNO 7 _ M007!TransmitRequestNO 7 _ M006+GetSQLString routineNO7 _ M005/Foreign schema supportNO 7 _ M004+Foreign data supportNO)partially supported 7 _ M0037Datalinks via Embedded SQLNO 7 _ M002-Datalinks via SQL/CLINO 7 _ M001DatalinksNO 7 _ T655=Cyclically dependent routines YES 7 _ T654YSQL-dynamic statements in external routinesNO 7 _ T653WSQL-schema statements in external routinesNO 7 _ T652OSQL-dynamic statements in SQL routinesNO 7 _ T651MSQL-schema statements in SQL routines YES 7 _ T6417Multiple column assignmentNOIonly some syntax variants supported 7 _ T631GIN predicate with one list element YES 7 _ T6217Enhanced numeric functions YES 7 _ T620;WINDOW clause: GROUPS optionNO7 _ T6191Nested window functionsNO 7 _ T618'NTH_VALUE functionNOUfunction exists, but some options missing 7 _ T617IFIRST_VALUE and LAST_VALUE function YES7 _ T616cNull treatment option for LEAD and LAG functionsNO m ,8 ??? X?? ?? ?? ??v P?v ?? ??? p?? ?? ?? ??? @?? ? ??? P?? ? ??? H?? ? ??z h?x (?~ ?v ??l h?? (?? ?X ??~ x?? 0?? ??? ??? P?? ?f ?? ??? P?| ?t ?? ??? (?? ?? x?? ?? ?? p?? ?? ?x ??? 0?? ?z ??? `?? ?~ ??? ??? P?? ?? ??? `?? 0?X ? ??? X?? ?? ??? ??? 8?? 7 E _ X410CAlter column data type: XML type YES 7 D _ X4009Name and identifier mapping YES7 C _ X305UXMLTable: initializing an XQuery variableNO 7 B _ X304CXMLTable: passing a context itemNO 7 A _ X303AXMLTable: column default optionNO 7 @ _ X302GXMLTable: ordinality column optionNO 7 ? _ X301KXMLTable: derived column list optionNO7 > _ X300XMLTableNO 7 = _ X286]XMLValidate: NO NAMESPACE with ELEMENT clauseNO 7 < _ X284[XMLValidate NAMESPACE without ELEMENT clauseNO7 ; _ X283CXMLValidate with SEQUENCE optionNO 7 : _ X282AXMLValidate with CONTENT optionNO 7 9 _ X281EXMLValidate: with DOCUMENT optionNO 7 8 _ X274;XMLValidate: schema locationNO7 7 _ X2739XMLValidate: ELEMENT clauseNO 7 6 _ X272CXMLValidate: ACCORDING TO clauseNO 7 5 _ X271=XMLValidate: data-driven caseNO 7 4 _ X2645XML type: schema locationNO 7 3 _ X263WXML type: NO NAMESPACE with ELEMENT clauseNO 7 2 _ X261WXML type: NAMESPACE without ELEMENT clauseNO 7 1 _ X2603XML type: ELEMENT clauseNO 7 0 _ X257mPersistent XML values of XML(CONTENT(XMLSCHEMA)) typeNO 7 / _ X256oPersistent XML values of XML(DOCUMENT(XMLSCHEMA)) typeNO 7 . _ X255YPersistent XML values of XML(SEQUENCE) typeNO 7 - _ X254aPersistent XML values of XML(CONTENT(ANY)) typeNO 7 , _ X253iPersistent XML values of XML(CONTENT(UNTYPED)) typeNO 7 + _ X252cPersistent XML values of XML(DOCUMENT(ANY)) typeNO 7 * _ X251kPersistent XML values of XML(DOCUMENT(UNTYPED)) typeNO7 ) _ X242KRETURNING SEQUENCE in XML publishingNO7 ( _ X241IRETURNING CONTENT in XML publishingNO 7 ' _ X232/XML(CONTENT(ANY)) typeNO 7 & _ X2317XML(CONTENT(UNTYPED)) typeNO 7 % _ X222;XML passing mechanism BY REFNO7 $ _ X221?XML passing mechanism BY VALUENO 7 # _ X211!XML 1.1 supportNO 7 " _ X206?XMLQuery: NULL ON EMPTY optionNO 7 ! _ X205AXMLQuery: EMPTY ON EMPTY optionNO 7 _ X204UXMLQuery: initializing an XQuery variableNO 7 _ X203CXMLQuery: passing a context itemNO 7 _ X202;XMLQuery: RETURNING SEQUENCENO7 _ X2019XMLQuery: RETURNING CONTENTNO 7 _ X200XMLQueryNO 7 _ X192;XML(CONTENT(XMLSCHEMA)) typeNO7 _ X191=XML(DOCUMENT(XMLSCHEMA)) typeNO 7 _ X190'XML(SEQUENCE) typeNO 7 _ X1821XML(DOCUMENT(ANY)) typeNO 7 _ X1819XML(DOCUMENT(UNTYPED)) typeNO 7 _ X1713NIL ON NO CONTENT optionNO 7 _ X1705XML null handling optionsNO 7 _ X161oAdvanced Information Schema for registered XML SchemasNO 7 _ X160iBasic Information Schema for registered XML SchemasNO 7 _ X157kIS VALID predicate: NO NAMESPACE with ELEMENT clauseNO7 _ X155kIS VALID predicate: NAMESPACE without ELEMENT clauseNO7 _ X153QIS VALID predicate with SEQUENCE optionNO 7 _ X152OIS VALID predicate with CONTENT optionNO 7 _ X151QIS VALID predicate with DOCUMENT optionNO 7 _ X145[IS VALID predicate outside check constraintsNO7 _ X144IIS VALID predicate: schema locationNO 7 _ X143GIS VALID predicate: ELEMENT clauseNO 7 _ X142QIS VALID predicate: ACCORDING TO clauseNO 7 _ X141KIS VALID predicate: data-driven caseNO7 _ X135?XMLBINARY clause in subqueriesNO 7 _ X134QXMLBINARY clause in compound statementsNO 7 _ X1331XMLBINARY clause in DDLNO 7 _ X1321XMLBINARY clause in DMLNO 7 _ X131;Query-level XMLBINARY clauseNO7 _ X121IXML parameters in external routines YES7 _ X120?XML parameters in SQL routines YES 7 _ X114uHost language support for XML: PRESERVE WHITESPACE optionNO
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de