Pg boolean false values displayed as <null>

[jplindstrom]

Hi!

I have a field like this:

    boolean "is_test" NOT NULL DEFAULT false

And it looks like when I get a false value out of this table, it's always displayed as a <null> value. The actual usage of it seems to work, e.g. I can do where, group by true/false, but the display of the false value is not correct. True works.

This seems like a general display issue. The simplest way to reproduce would be:

select false as boolean_false, true as boolean_true;
| boolean_false | boolean_true |
|---------------+--------------|
| NULL          | t            |

When I run this in psgl it does display f

[LuciusChen]

Root cause: pg-el represents both PostgreSQL boolean false and SQL NULL as Emacs nil by default, so Clutch could not distinguish them and rendered false as .

Fixed in 88c69d6 by using a distinct NULL marker at the PostgreSQL adapter boundary and preserving boolean false separately. The issue is intentionally left open for verification.

[jplindstrom]

This now shows

select false as boolean_false, true as boolean_true;

| boolean_false | boolean_true |
|---------------+--------------|
| false         | t            |

These all work, but maybe they should share the same shape, i.e. either true/false or t/f?

The psql cli uses t/f.

[LuciusChen]

Fixed in 981d66d — true now renders as true as well, so boolean values consistently use the true/false shape everywhere (result table, preview, copy/export, edit prefill). psql shows t/f, while DataGrip's Text mode shows true/false; Clutch follows the latter.