6.7 Supported PGQL Features and Limitations
- PGQL on RDBMS (PG_VIEW)
- PGQL on RDBMS (PG_SCHEMA)
- PGQL on the graph server (PGX)
Table 6-2 Supported PGQL Functionalities and Limitations
Feature | PGQL on RDBMS (PG_VIEW) | PGQL on RDBMS (PG_SCHEMA) | PGQL on the Graph Server (PGX) |
---|---|---|---|
CREATE PROPERTY GRAPH |
Supported | Supported | Supported
Limitations:
|
DROP PROPERTY GRAPH |
Supported | Supported | Not Supported |
Fixed-length pattern matching | Supported | Supported | Supported |
Variable-length pattern matching goals | Supported:
Limitations:
|
Supported:
Limitations:
|
Supported:
|
Variable-length pattern matching quantifiers | Supported:
|
Supported:
|
Supported:
Limitations:
|
Variable-length path unnesting | Not supported | Not supported | Supported:
Limitation:
|
GROUP BY |
Supported | Supported | Supported |
HAVING |
Supported | Supported | Supported |
Aggregations | Supported:
Limitations:
|
Supported:
Limitations:
|
Supported:
Limitations:
|
DISTINCT
|
Supported | Supported | Supported |
SELECT v.* |
Supported | Not Supported | Supported |
ORDER BY (+ASC/DESC), LIMIT,
OFFSET |
Supported | Supported | Supported |
Data Types | All available Oracle RDBMS data types supported | Supported:
|
Supported:
|
JSON | Supported:
|
No built-in JSON support. However, JSON strings
(VARCHAR2 ) can be mapped into
NVARCHAR2(15000) data type.
|
No built-in JSON support. However, JSON values can
be stored as STRING and manipulated or queried
through user-defined functions (UDFs) written in Java or
JavaScript.
|
Operators | Supported:
|
Supported:
Limitations:
|
Supported:
|
Functions and predicates |
Supported are all available functions in the Oracle
RDBMS that take the form Supported PGQL functions/predicates:
Limitations:
|
Supported:
Limitations:
|
Supported:
|
User-defined functions | Supported:
|
Not supported | Supported:
|
Subqueries:
|
Supported | Supported | Supported |
INSERT/UPDATE/DELETE |
Supported for Oracle Database 19c and later | Supported for Oracle Database 19c and later | Supported |
INTERVAL literals and
operations
|
Not supported | Not supported |
Supported literals:
Supported operations:
|
Parent topic: Property Graph Query Language (PGQL)