3 ms·
Quite easy: select * from unitType where info->>'$.maxSqft' > ? If you want it to be indexed for production use, that's also pretty easy: alter table uni
by dcposch 9y ago
Quite easy:
select * from unitType where info->>'$.maxSqft' > ?
If you want it to be indexed for production use, that's also pretty easy:
alter table unitType add column maxSqft float as info->>'$.maxSqft'
alter table unitType add key(maxSqft)
...
select * from unitType where maxSqft > ?