On Sat, Mar 21, 2020 at 4:37 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
> Anyway, It will be awesome if we have a sequence data type in a future
> version of postgresql. They will solve a lot of problems similar to this
> one.
Actually there are already two:
https://www.postgresql.org/docs/12/datatype-numeric.html#DATATYPE-SERIAL
https://www.postgresql.org/docs/12/sql-createtable.html
"
GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( sequence_options ) ]
This clause creates the column as an identity column. It will have
an implicit sequence attached to it and the column in new rows will
automatically have values from the sequence assigned to it.
"
What you want is a built in method to pull from different sequences
depending on the value of another column or values from multiple columns
in the same table.
Exactly. That will work fine too.
