Outerbase Studio shows Null for "interval" type field in postgresql
I am testing Outerbase Studio with a Postgresql database created in django. When I read it with Outerbase Studio the fields of type "interval" are showed as NULL. In Django I can read the right values. Is this a limitation of Outerbase Studio or am I doing something wrong? If I manually perform the query like this, the data is properly showed: SELECT "timeIrrigation"::TEXT AS time_str FROM farms_historictimeirrigation ORDER BY "id" DESC LIMIT 1;
but it shows null if I use: SELECT * FROM farms_historictimeirrigation ORDER BY "id" DESC LIMIT 1;
Are you using desktop version? @roth-dev can you check interval type for PostgreSQL?
Yes, desktop version in MacOs
I'll take a look into your case.
Should be fix by this PR: outerbase/sdk-transform#5