I found an issue in PgAdmin. It seems the UI is not able to render
arrays of dateranges and thus displays nothing at all.
* Platform: MacOS
* Languag: English
* Distribution: binary
* Version: 4.13
To reproduce:
1. CREATE TABLE dates_test(dates DATERANGE[]);
2. INSERT INTO dates_test VALUES
('{"(2016-01-01,2017-01-01)"}'::DATERANGE[]);
3. SELECT dates FROM dates_test;
* shows nothing in Data Output in pgAdmin
4. SELECT dates::VARCHAR FROM public.dates_test;
* works as expected and shows the one inserted row as
{"[2016-01-02,2017-01-01)"}
A coworker on Windows 10 has the same problem.
Regards,
Manuel Hegner