Hello,
I have a postgres table with inheritance, I want to write a DAO for, which
I want to derive from DAOImpl. Now DAOImpl expects the table to be of type
UpdatetableRecord: DAOImpl, P, T>. What would
be the best way to implement a class working on an inherited table with
jOOQ?
Best
Hello David,
I'm assuming you plan to be using the code generator, which unfortunately
does not support PostgreSQL table inheritance yet. There are a few pending
feature requests:
- https://github.com/jOOQ/jOOQ/issues/2777
- https://github.com/jOOQ/jOOQ/issues/2782
Also related: Oracle OBJECT
Hello Lucas,
the use case is I want to store typed metadata, e.g. numbers, strings,
boolean and geolocation, like this:
CREATE TYPE meta.metadata_type AS ENUM ('int32', 'float64', 'string',
'lnglat', 'boolean');
CREATE TABLE meta.metadata (
uuid uuid NOT NULL,