I would like to create a new type for version strings that sorts numerically. The composite type below was quick to write and does not require superuser privileges. However, it doesn't respond to type casts the way I'd like.
Is there a way to implement this type's literal conversion without resorting to a base type?
I think you need to define casts too, but in any way - check if "semver" extension (available on pgxn) doesn't solve your problem.