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

Reply via email to