Georg Traar

Support `pg_catalog.pg_is_in_recovery()`

1

**Problem Statement**: Although CrateDB's architecture differs from PostgreSQL in terms of high availability, replication, and recovery, many PostgreSQL tools (e.g. Jetbrains Datagrip) and applications rely on the built-in function `pg_is_in_recover`y...

Support for individual indexing of OBJECTs in arrays (nested type)

2

**Use case**: As a user I want to be able to have information stored in arrays, but still be able to make a selection on logical combinations of individual object...

**Use case**: For multi-zone setups or special allocation strategies (e.g. warm, cold) it would be good to expose the set node attributes in the `sys.nodes` system table. This might help...

Adding columns/properties to `OBJECT(IGNORED)` leads to inconsistencies

1

**Use case**: When adding indexed object properties to `OBJECT(IGNORED)` columns, one might end up with inconsistent results only records after index was added get returned ```sql CREATE TABLE test_obj (obj...

Feature request: Testing for (in)equality with geo_points

5

Relates to #7997 **Use case**: As a user I want to check geo_points for (in)equality to filter for certain fixed locations (e.g. 0 0 or others) **Feature description**: The equality...

Support for a `DYNAMIC` or `ARBITRARY` data type

3

**Use case**: When capturing various data streams (e.g. http-requests, opc-ua) in CrateDB, one might come across various types of data encapsulated in a single message/payload. In order to ingest and...

Support `INTERVAL` values as input for `extract(field from source)`

1

### Problem Statement To calculate the difference between two `DATE` or `TIMESTAMP` values, one can use the `age(,)` function, which returns an `INTERVAL`. This is fine, if one can directly...

Release packages for RHEL / CentOS 8 and 9

1

### Problem Statement Provide (yum/rpm) releases packages for RHEL and CentOS 8 and 9 (and other compatible Linux distributions) ### Possible Solutions _No response_ ### Considered Alternatives _No response_

Add support for merging two objects into a new one

3

### Problem Statement I came across this, when looking into the[ CrateDB Telegraf Plugin](https://github.com/influxdata/telegraf/blob/master/plugins/outputs/cratedb/cratedb.go). Telegraf / Influx uses `tags` (key/value) and a `name` to identify a collection of metrics. e.g....

**Use case**: > _**From postgresql.org**_ > While the standard syntax for specifying string constants is usually convenient, it can be difficult to understand when the desired string contains many single...