bloomberg / bloomberg/comdb2

Comdb2 Postgres SQL Equivalents

Open
#554 16 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
C
Stars
1.5k
Forks
243
Avg merge
2d 2h
Merged PRs (30d)
37

Description

What would be the equivalents of the following PostgresSQL constructs in ComDB2. I've consulted the documentation and could not find it(These are related to `CREATE TABLE` statements):

1. `DEFAULT CURRENT_TIMESTAMP`: Setting a timestamp(or any) column default value
2. `UNIQUE`: Applying a unique constraint
3. `o_carrier_id int NULL DEFAULT NULL`
4. `decimal(6, 2)`: I actually tried `decimal32` for this but it throws the following error log
`incompatible values from SQL real '5.000000' to decimal field 'ol_quantity' for table 'order_line'`.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.