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:
- CREATE TABLE dates_test(dates DATERANGE[]);
- INSERT INTO dates_test VALUES ('{"(2016-01-01,2017-01-01)"}'::DATERANGE[]);
- SELECT dates FROM dates_test;
- shows nothing in Data Output in pgAdmin
- 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