Re: Is there a good way to handle sum types (or tagged unions) in PostgreSQL?

[Adrian Klaver]

On 5/18/23 05:27, Victor Nordam Suadicani wrote:

Hi,

Is there any nice way to handle sum types (aka tagged unions) in a PostgreSQL database? I've searched far and wide and have not reached any satisfying answer.

As a (somewhat contrived) example, say I have the following enum in Rust:

enum TaggedUnion {
     Variant1(String),
     Variant2(i32),
     Variant3(f64),
}

If there are no good methods of handling this, is there any way PostgreSQL could be extended with capabilities for this? I have no idea how this would be done in practice though. Perhaps SQL itself is just unsuited for data of this kind? I don't really see why it should be though.

Composite type?:

https://www.postgresql.org/docs/current/rowtypes.html

Thanks,
Victor Nordam Suadicani

--
Adrian Klaver
adrian.kla...@aklaver.com