Core SQL Compatibility
CedarDB implements the SQL dialect of PostgreSQL. While we are able to syntactically parse any PostgreSQL-compliant statement, not all underlying functionality is implemented yet.
This page gives a non-exhaustive overview of currently supported core SQL functionality. CedarDB strives for full PostgreSQL compatibility, and features not currently supported will be added over time.
For PostgreSQL-specific functionality, such as system table support, see the system table compatibility page.
Data Definition
Table Creation & Deletion
| Feature | Support State | Details |
|---|---|---|
| CREATE TABLE | Yes | Documentation |
| DROP TABLE | Yes | |
| Default Values | Yes | |
| GENERATED AS IDENTITY | Yes | Both ALWAYS and BY DEFAULT variants |
| GENERATED ALWAYS AS (computed) | No | |
| Check Constraints | Yes | Only at CREATE TABLE time. Documentation |
| Not-Null Constraints | Yes | Documentation |
| Unique Constraints | Yes | Documentation |
| Primary Keys | Yes | Documentation |
| Foreign Keys | Yes | Documentation |
| FK ON DELETE CASCADE | Yes | |
| FK ON DELETE RESTRICT | Yes | |
| FK ON DELETE NO ACTION | Yes | |
| FK ON UPDATE CASCADE | Yes | |
| FK ON DELETE SET NULL | No | |
| FK ON DELETE SET DEFAULT | No | |
| Named Constraints | Yes | For PRIMARY KEY, UNIQUE, FOREIGN KEY, and CHECK. Documentation |
| Exclusion Constraints | No | |
| System Columns | Yes | Only meaningful for tableoid and ctid |
| UNLOGGED TABLE | No | |
| CREATE TABLE LIKE | Partial | Copies column names and types. INCLUDING options not supported |
| DROP TABLE CASCADE | No |
Table Modification (ALTER TABLE)
| Feature | Support State | Details |
|---|---|---|
| ADD COLUMN | Yes | |
| ADD COLUMN IF NOT EXISTS | Yes | |
| DROP COLUMN | Yes | |
| DROP COLUMN IF EXISTS | Yes | |
| DROP COLUMN CASCADE | Yes | |
| RENAME COLUMN | Yes | |
| RENAME TO | Yes | |
| ADD CHECK | No | Only at CREATE TABLE time |
| ADD CONSTRAINT (PRIMARY KEY) | Yes | Documentation |
| ADD CONSTRAINT (UNIQUE) | Yes | Documentation |
| ADD CONSTRAINT (FOREIGN KEY) | Yes | Documentation |
| DROP CONSTRAINT | Yes | Documentation |
| DROP CONSTRAINT IF EXISTS | Yes | |
| DROP CONSTRAINT CASCADE | Yes | |
| RENAME CONSTRAINT | No | |
| ALTER COLUMN SET/DROP DEFAULT | No | |
| ALTER COLUMN SET/DROP NOT NULL | No | |
| ALTER COLUMN TYPE | No | |
| SET SCHEMA | No | |
| OWNER TO | Yes | |
| ENABLE/DISABLE ROW LEVEL SECURITY | Yes | CREATE POLICY requires an enterprise license |
| FORCE/NO FORCE ROW LEVEL SECURITY | Yes | |
| SET TABLESPACE | No | |
| CLUSTER ON / SET WITHOUT CLUSTER | No | |
| ATTACH / DETACH PARTITION | No | |
| ENABLE/DISABLE TRIGGER | No | Triggers are not implemented |
| VALIDATE CONSTRAINT | No |
Privileges
| Feature | Support State | Details |
|---|---|---|
| CREATE ROLE | Yes | Documentation |
| OWNER TO | Yes | |
| ALTER ROLE | Yes | Documentation |
| GRANT | Yes | Requires an enterprise license |
| REVOKE | Yes | Requires an enterprise license |
| SET ROLE | Yes | Requires an enterprise license |
| INHERIT | Yes | Documentation |
| Row Security Policies | Yes | Requires an enterprise license |
Indexes
| Feature | Support State | Details |
|---|---|---|
| CREATE INDEX | Yes | Only B-Tree Indexes Documentation |
| GIN | No | |
| BRIN | No | |
| Multicolumn Indexes | Yes | Documentation |
| Ordered Indexes | Yes | Documentation |
| Unique Indexes | Yes | |
| Indexes on Expressions | No | |
| Partial Indexes | No |
Misc
| Feature | Support State | Details |
|---|---|---|
| CREATE SCHEMA | Yes | Documentation |
| DROP SCHEMA | Yes | Only if the schema is empty |
| search_path | Yes | Documentation |
| Table Inheritance | No | |
| Table Partitioning | Partial | Only hash partitioning. Only at CREATE TABLE time |
| Foreign Data Wrappers | No | |
| Views | Yes | Documentation |
| Databases | Yes | Documentation |
| Functions & Procedures | Yes | Documentation Also in cedar_script language |
| Custom Types | No | |
| Triggers | No | |
| Prepared Statements | Yes | |
| Advisory Locks | Yes | Documentation |
Data Manipulation
| Feature | Support State | Details |
|---|---|---|
| INSERT | Yes | Documentation |
| UPDATE | Yes | Documentation |
| DELETE | Yes | Documentation |
| TRUNCATE | Yes | Documentation |
| RETURNING | Yes | Documentation |
| COPY FROM | Yes | Documentation |
| COPY TO | Yes | Documentation |
| ON CONFLICT | Yes | Documentation |
Queries
| Feature | Support State | Details |
|---|---|---|
| Table & View References | Yes | |
| Inner Joins | Yes | Documentation |
| Outer Joins | Yes | Documentation |
| Semijoins | Yes | Documentation |
| Antijoins | Yes | |
| Table Functions | Yes | |
| Lateral Subqueries | Yes | |
| User-Specified Aliases | Yes | |
| GROUP BY | Yes | Documentation |
| HAVING | Yes | Documentation |
| GROUPING SETS | Yes | |
| CUBE | Yes | |
| ROLLUP | Yes | |
| WINDOW Functions | Yes | Documentation |
| WITH | Yes | Documentation |
| WITH RECURSIVE | Yes | |
| UNION | Yes | |
| UNION ALL | Yes | |
| INTERSECT | Yes | |
| EXCEPT | Yes | |
| ORDER BY | Yes | |
| LIMIT | Yes | |
| OFFSET | Yes | |
| Table Generating Function | Yes |
Data Types
Types
| Feature | Support State | Details |
|---|---|---|
| array | Yes | Array Documentation |
| bigint | Yes | Integer Documentation |
| bigserial | Yes | |
| bit [ (n) ] | Yes | Bit Documentation |
| bit varying [ (n) ] | Yes | Bit Documentation |
| boolean | Yes | Boolean Documentation |
| box | No | |
| bytea | Yes | Blob Documentation |
| character [ (n) ] | Yes | Text Documentation |
| character varying [ (n) ] | Yes | Text Documentation |
| cidr | No | |
| circle | No | |
| date | Yes | Date Documentation |
| double precision | Yes | Double Documentation |
| inet | No | |
| integer | Yes | Integer Documentation |
| interval [ fields ] [ (p) ] | Yes | Interval Documentation |
| json | Yes | JSON Documentation |
| jsonb | Yes | JSON Documentation |
| line | No | |
| lseg | No | |
| macaddr | No | |
| macaddr8 | No | |
| money | No | |
| numeric [ (p, s) ] | Yes | Numeric Documentation |
| path | No | |
| pg_lsn | No | |
| pg_snapshot | No | |
| point | No | |
| polygon | No | |
| real | Yes | Float Documentation |
| smallint | Yes | Integer Documentation |
| smallserial | Yes | |
| serial | Yes | |
| text | Yes | Text Documentation |
| time [ (p) ] [ without time zone ] | Yes | Time Documentation |
| time [ (p) ] with time zone | Yes | Time Documentation |
| timestamp [ (p) ] [ without time zone ] | Yes | Timestamp Documentation |
| timestamp [ (p) ] with time zone | Yes | Timestamp Documentation |
| tsquery | No | |
| tsvector | No | |
| txid_snapshot | No | |
| uuid | Yes | UUID Documentation |
| xml | No |
Operators & Functions
Logical
| Feature | Support State | Details |
|---|---|---|
| AND | Yes | |
| OR | Yes | |
| NOT | Yes |
Comparison
| Feature | Support State | Details |
|---|---|---|
| < | Yes | |
| > | Yes | |
| <= | Yes | |
| >= | Yes | |
| = | Yes | |
| <> | Yes | |
| != | Yes | |
| BETWEEN | Yes | |
| NOT BETWEEN | Yes | |
| IS DISTINCT | Yes | |
| IS NOT DISTINCT | Yes | |
| IS NULL | Yes | |
| IS NOT NULL | Yes | |
| IS TRUE | Yes | |
| IS NOT TRUE | Yes | |
| IS FALSE | Yes | |
| IS NOT FALSE | Yes | |
| IS UNKNOWN | Yes | |
| IS NOT UNKNOWN | Yes |
Mathematical
| Feature | Support State | Details |
|---|---|---|
| + | Yes | |
| - | Yes | |
| * | Yes | |
| / | Yes | |
| % | Yes | |
| ^ | Yes | |
| |/ | Yes | |
| ||/ | Yes | |
| @ | Yes | |
| & | Yes | |
| | | Yes | |
| # | Yes | |
| ~ | Yes | |
| << | Yes | |
| >> | Yes | |
| abs | Yes | |
| cbrt | Yes | |
| ceil | Yes | |
| degrees | Yes | |
| div | Yes | |
| erf | No | |
| erfc | No | |
| exp | Yes | |
| factorial | Yes | Also exists as ! operand |
| floor | Yes | |
| gcd | Yes | Missing support for numeric input type. Supports int4, uint8, int8. |
| lcm | No | |
| ln | Yes | |
| log | Yes | |
| log10 | Yes | |
| min_scale | No | |
| mod | Yes | |
| pi | Yes | |
| power | Yes | |
| radians | Yes | |
| round | Yes | |
| scale | No | |
| sign | Yes | |
| sqrt | Yes | |
| trim_scale | No | |
| trunc | Yes | |
| width_bucket | Yes | |
| random | Yes | |
| random_normal | No | |
| setseed | No | |
| acos | Yes | |
| acosd | Yes | |
| asin | Yes | |
| asind | Yes | |
| atan | Yes | |
| atand | Yes | |
| atan2 | Yes | |
| atan2d | Yes | |
| cos | Yes | |
| cosd | Yes | Because of rounding errors, cosd is not exactly 0 for its zero points. |
| cot | Yes | |
| cotd | Yes | For the values where cotd is undefined, the value of the C++ library is returned. |
| sin | Yes | |
| sind | Yes | Because of rounding errors, cosd is not exactly 0 for its zero points. |
| tan | Yes | |
| tand | Yes | For the values where tand is undefined, the value of the C++ library is returned. |
| sinh | Yes | |
| cosh | Yes | |
| tanh | Yes | |
| asinh | Yes | |
| acosh | Yes | |
| atanh | Yes |
Text
| Feature | Support State | Details |
|---|---|---|
| || | Yes | |
| btrim | Yes | |
| bit_length | Yes | |
| char_length | Yes | |
| lower | Yes | |
| lpad | Yes | |
| ltrim | Yes | |
| normalize | No | |
| octet_length | Yes | |
| overlay | Yes | |
| position | Yes | |
| rpad | Yes | |
| rtrim | Yes | |
| substring | Yes | Currently not supporting regular expression arguments |
| trim | Yes | |
| upper | Yes | |
| ^@ | No | |
| ascii | Yes | |
| chr | Yes | |
| concat | Yes | |
| concat_ws | Yes | |
| format | Yes | |
| initcap | Yes | |
| left | Yes | |
| length | Yes | |
| md5 | Yes | |
| parse_ident | Yes | |
| quote_ident | Yes | |
| quote_literal | Yes | |
| quote_nullable | Yes | |
| repeat | Yes | |
| replace | Yes | |
| reverse | Yes | |
| right | Yes | |
| split_part | Yes | |
| starts_with | Yes | |
| string_to_array | Yes | |
| string_to_table | Yes | |
| strpos | Yes | |
| substr | Yes | |
| to_ascii | No | |
| to_hex | Yes | |
| translate | Yes | |
| unistr | No |
Bytea
| Feature | Support State | Details |
|---|---|---|
| || | Yes | |
| bit_length | Yes | |
| btrim | Yes | |
| ltrim | No | |
| octet_length | Yes | |
| overlay | Yes | |
| position | Yes | |
| rtrim | No | |
| substring | Yes | |
| trim | Yes | Only for BOTH direction |
| bit_count | No | |
| get_bit | No | |
| get_byte | Yes | |
| length | Yes | |
| md5 | Yes | |
| set_bit | Yes | |
| set_byte | Yes | |
| sha224 | No | |
| sha384 | No | |
| sha512 | No | |
| substr | Yes | |
| convert | Yes | Only for UTF8 |
| convert_from | Yes | Only for UTF8 |
| convert_to | Yes | Only for UTF8 |
| encode | Yes | |
| decode | Yes |
Bit
| Feature | Support State | Details |
|---|---|---|
| || | No | |
| & | No | |
| | | No | |
| # | No | |
| ~ | No | |
| << | No | |
| >> | No | |
| bit_count | Yes | |
| bit_length | Yes | |
| length | No | |
| octet_length | Yes | |
| overlay | Yes | |
| position | Yes | |
| substring | Yes | |
| get_bit | Yes | |
| set_bit | Yes |
Pattern Matching
| Feature | Support State | Details |
|---|---|---|
| LIKE | Yes | |
| SIMILAR TO | Yes | |
| regexp_count | Yes | |
| regexp_instr | Yes | |
| regexp_like | Yes | |
| regexp_match | Yes | |
| regexp_matches | Yes | |
| regexp_replace | Yes | Currently not supporting replacing N’th match |
| regexp_split_to_array | Yes | |
| regexp_split_to_table | Yes | |
| regexp_substr | Yes |
Data Type Formatting
| Feature | Support State | Details |
|---|---|---|
| to_char | Yes | Most used patterns |
| to_date | No | |
| to_number | No | |
| to_timestamp | No |
Date/Time
| Feature | Support State | Details |
|---|---|---|
| + | Yes | |
| - | Yes | |
| * | Yes | |
| / | Yes | |
| age | Yes | |
| clock_timestamp | Yes | |
| current_date | Yes | |
| current_time | Yes | |
| current_timestamp | Yes | |
| date_add | No | possible with + |
| date_bin | No | |
| date_part | Yes | |
| date_subtract | No | possible with - |
| date_trunc | Yes | Without timezone |
| extract | Yes | |
| isfinite | No | |
| justify_days | Yes | |
| justify_hours | Yes | |
| justify_interval | Yes | |
| localtime | Yes | |
| localtimestamp | Yes | |
| make_date | No | |
| make_interval | No | |
| make_time | No | |
| make_timestamp | No | |
| make_timestamptz | Yes | |
| now | Yes | |
| statement_timestamp | No | |
| timeofday | No | |
| transaction_timestamp | No | |
| to_timestamp | Yes | |
| OVERLAPS | Yes | |
| EXTRACT | Yes |
Enum
| Feature | Support State | Details |
|---|---|---|
| enum_first | No | |
| enum_last | No | |
| enum_range | No |
Geometric
| Feature | Support State | Details |
|---|---|---|
| + | No | |
| - | No | |
| * | No | |
| / | No | |
| @-@ | No | |
| @@ | No | |
| # | No | |
| ## | No | |
| <-> | No | |
| @> | No | |
| <@ | No | |
| && | No | |
| << | No | |
| >> | No | |
| &< | No | |
| &> | No | |
| <<| | No | |
| |>> | No | |
| &<| | No | |
| |&> | No | |
| <^ | No | |
| >^ | No | |
| ?# | No | |
| ?- | No | |
| ?| | No | |
| ?-| | No | |
| ?|| | No | |
| ~= | No | |
| area | No | |
| center | No | |
| diagonal | No | |
| diameter | No | |
| height | No | |
| isclosed | No | |
| isopen | No | |
| length | No | |
| npoints | No | |
| pclose | No | |
| popen | No | |
| radius | No | |
| slope | No | |
| width | No | |
| box | No | |
| bounding_box | No | |
| circle | No | |
| line | No | |
| lseg | No | |
| path | No | |
| point | No | |
| polygon | No |
Network
| Feature | Support State | Details |
|---|---|---|
| << | No | |
| <<= | No | |
| >> | No | |
| >>= | No | |
| && | No | |
| ~ | No | |
| & | No | |
| | | No | |
| + | No | |
| - | No | |
| abbrev | No | |
| broadcast | No | |
| family | No | |
| host | No | |
| hostmask | No | |
| inet_merge | No | |
| inet_same_family | No | |
| masklen | No | |
| netmask | No | |
| network | No | |
| set_masklen | No | |
| text | No |
Text Search
| Feature | Support State | Details |
|---|---|---|
| @@ | No | |
| || | No | |
| && | No | |
| !! | No | |
| <-> | No | |
| @> | No | |
| <@ | No | |
| array_to_tsvector | No | |
| get_current_ts_config | No | |
| length | No | |
| numnode | No | |
| plainto_tsquery | No | |
| phraseto_tsquery | No | |
| websearch_to_tsquery | No | |
| querytree | No | |
| setweight | No | |
| strip | No | |
| to_tsquery | No | |
| to_tsvector | No | |
| json(b)_to_tsvector | No | |
| ts_delete | No | |
| ts_filter | No | |
| ts_headline | No | |
| ts_rank | No | |
| ts_rank_cd | No | |
| ts_rewrite | No | |
| tsquery_phrase | No | |
| tsvector_to_array | No | |
| unnest | No | |
| ts_debug | No | |
| ts_lexize | No | |
| ts_parse | No | |
| ts_token_type | No | |
| ts_stat | No |
UUID
| Feature | Support State | Details |
|---|---|---|
| get_random_uuid | Yes | |
| uuid_extract_timestamp | No | |
| uuid_extract_version | No |
XML
| Feature | Support State | Details |
|---|---|---|
| xmltext | No | |
| xmlcomment | No | |
| xmlconcat | No | |
| xmlelement | No | |
| xmlforest | No | |
| xmlpi | No | |
| xmlroot | No | |
| xmlagg | No | |
| IS DOCUMENT | No | |
| IS NOT DOCUMENT | No | |
| XMLEXISTS | No | |
| xml_is_well_formed | No | |
| xpath | No | |
| xpath_exists | No | |
| XMLTABLE | No |
JSON
| Feature | Support State | Details |
|---|---|---|
| -> | Yes | |
| ->> | Yes | |
| #> | No | |
| #>> | No | |
| @> | Yes | |
| <@ | Yes | |
| ? | Yes | |
| ?| | Yes | |
| ?& | Yes | |
| || | No | |
| - | No | |
| #- | No | |
| @? | No | |
| @@ | No | |
| to_json | Yes | |
| to_jsonb | No | |
| array_to_json | No | |
| json_array | No | |
| row_to_json | No | |
| json_build_array | No | |
| jsonb_build_array | No | |
| json_build_object | No | |
| jsonb_build_object | No | |
| json_object | No | |
| jsonb_object | No | |
| IS JSON | No | |
| json_array_elements | Yes | |
| jsonb_array_elements | Yes | |
| json_array_elements_text | No | |
| jsonb_array_elements_text | No | |
| json_array_length | Yes | |
| jsonb_array_length | No | |
| json_each | No | |
| jsonb_each | No | |
| json_each_text | No | |
| jsonb_each_text | No | |
| json_object_keys | No | |
| jsonb_object_keys | No | |
| json_populate_record | No | |
| jsonb_populate_record | No | |
| json_populate_recordset | No | |
| jsonb_populate_recordset | No | |
| json_to_record | No | |
| jsonb_to_record | No | |
| json_to_recordset | No | |
| jsonb_to_recordset | No | |
| jsonb_set | No | |
| jsonb_set_lax | No | |
| jsonb_insert | No | |
| json_strip_nulls | No | |
| jsonb_strip_nulls | No | |
| json_path | No |
Sequence Manipulation
| Feature | Support State | Details |
|---|---|---|
| nextval | Yes | |
| setval | Yes | |
| currval | No | |
| lastval | No | |
| pg_get_serial_sequence | Yes |
Conditional
| Feature | Support State | Details |
|---|---|---|
| CASE | Yes | |
| COALESCE | Yes | |
| NULLIF | Yes | |
| GREATEST | Yes | |
| LEAST | Yes |
Array
| Feature | Support State | Details |
|---|---|---|
| @> | Yes | |
| <@ | Yes | |
| && | No | |
| || | Yes | Not for multidimensional |
| array_append | Yes | |
| array_cat | Yes | |
| array_dims | Yes | |
| array_fill | Yes | |
| array_lower | Yes | |
| array_ndims | Yes | |
| array_position | Yes | |
| array_positions | Yes | |
| array_prepend | Yes | |
| array_remove | Yes | |
| array_replace | Yes | |
| array_sample | No | |
| array_shuffle | No | |
| array_to_string | Yes | |
| array_upper | Yes | |
| array_cardinality | Yes | |
| trim_array | Yes | |
| unnest | Yes | No multi-array expansion |
Range
| Feature | Support State | Details |
|---|---|---|
| @> | Yes | |
| <@ | Yes | |
| && | Yes | |
| << | Yes | |
| >> | Yes | |
| &< | Yes | |
| &> | Yes | |
| -|- | No | |
| + | No | |
| * | No | |
| - | No | |
| lower | Yes | |
| upper | Yes | |
| isempty | Yes | |
| lower_inc | Yes | |
| upper_inc | Yes | |
| lower_inf | Yes | |
| upper_inf | Yes | |
| range_merge | No | |
| multirange | No | |
| unnest | No |
Aggregate Functions
Generic
| Feature | Support State | Details |
|---|---|---|
| any_value | Yes | Aggregate Function Documentation |
| array_agg | Yes | Aggregate Function Documentation |
| avg | Yes | Aggregate Function Documentation |
| bit_and | Yes | Aggregate Function Documentation |
| bit_or | Yes | Aggregate Function Documentation |
| bit_xor | Yes | Aggregate Function Documentation |
| bool_and | Yes | Aggregate Function Documentation |
| bool_or | Yes | Aggregate Function Documentation |
| count(*) | Yes | Aggregate Function Documentation |
| count(“any”) | Yes | Aggregate Function Documentation |
| json(b)_agg | No | |
| json(b)_objectagg | No | |
| json(b)_object_agg | No | |
| json_arrayagg | No | |
| max | Yes | Aggregate Function Documentation |
| min | Yes | Aggregate Function Documentation |
| range(_intersect)_agg | No | |
| string_agg | Yes | Aggregate Function Documentation |
| sum | Yes | Aggregate Function Documentation |
| xmlagg | No |
Statistical
| Feature | Support State | Details |
|---|---|---|
| corr | No | |
| covar_pop | Yes | Aggregate Function Documentation |
| covar_samp | Yes | Aggregate Function Documentation |
| regr_avgx | Yes | Aggregate Function Documentation |
| regr_avgy | Yes | Aggregate Function Documentation |
| regr_count | Yes | Aggregate Function Documentation |
| regr_intercept | Yes | Aggregate Function Documentation |
| regr_r2 | Yes | Aggregate Function Documentation |
| regr_slope | Yes | Aggregate Function Documentation |
| regr_sxx | Yes | Aggregate Function Documentation |
| regr_sxy | Yes | Aggregate Function Documentation |
| regr_syy | No | |
| stddev | Yes | Aggregate Function Documentation |
| stddev_pop | Yes | Aggregate Function Documentation |
| stddev_samp | Yes | Aggregate Function Documentation |
| variance | Yes | Aggregate Function Documentation |
| var_pop | Yes | Aggregate Function Documentation |
| var_samp | Yes | Aggregate Function Documentation |
Ordered-Set
| Feature | Support State | Details |
|---|---|---|
| mode | Yes | Aggregate Function Documentation |
| percentile_cont | Yes | Aggregate Function Documentation |
| percentile_disc | Yes | Aggregate Function Documentation |
Window
| Feature | Support State | Details |
|---|---|---|
| row_number | Yes | |
| rank | Yes | |
| dense_rank | Yes | |
| percent_rank | Yes | |
| cume_dist | Yes | |
| ntile | Yes | |
| lag | Yes | |
| lead | Yes | |
| first_value | Yes | |
| last_value | Yes | |
| nth_value | Yes |
Subquery
| Feature | Support State | Details |
|---|---|---|
| EXISTS | Yes | |
| IN | Yes | |
| NOT IN | Yes | |
| ANY/SOME | Yes | |
| ALL | Yes |
Array Comparison
| Feature | Support State | Details |
|---|---|---|
| EXISTS | Yes | |
| IN | Yes | |
| NOT IN | Yes | |
| ANY/SOME | Yes | |
| ALL | Yes |
Set Returning
| Feature | Support State | Details |
|---|---|---|
| generate_series | Yes | |
| generate_subscript | Yes |
