You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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;
The text was updated successfully, but these errors were encountered:
gruporec
changed the title
Outerbase Studio shows Null for "interval" type field in postgressql
Outerbase Studio shows Null for "interval" type field in postgresql
Apr 20, 2025
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;
The text was updated successfully, but these errors were encountered: