Модульность базы данных (2)
JSONB как решение многих проблем
select customer ->> 'code' as code, customer -> 'name' ->> 'en' as name, amount from invoice
where (customer ->> ‘code') = ‘777'
code |name |amount |
-------|-----------|-----------|
777 |Kodality |19.50 |
777 |Kodality |19.50 |
777 |Kodality |37.65 |
777 |Kodality |9.00 |
777 |Kodality |9.00 |
777 |Kodality |16.50 |
777 |Kodality |16.50 |
select customer, amount from invoice
customer |amount|
-------------------------------------------------------------------------------------------------------------------------------|----------|
{"code": "000", "names": {"en": “Private person”, "ru": “Частное лицо”}} |11.40 |
{"code": "777", "names": {“en":“Kodality"}, "contact": “
[email protected]”} |19.50 |
{"code": “666", "names": {"en": “Nortal"}} |3.00 |