Re: COMPRESS VALUES feature request

On Tue, May 9, 2017 at 8:18 PM, Erez Segal <erezsegal(at)gmail(dot)com> wrote:

> In the IRC channel - johto suggested an implementation:
>
> <johto> if you want to get really fancy you could have two columns where
> only one of set; one would be the value (if reasonably unique) and the
> other the id (if not)
>

I only suggested how to do this in an application if one really wants the
feature so badly. I don't think this would fly as a native implementation.

> I'd like to add that an ENUM can be used instead of the id+lookup table in
> the 2nd column for non unique values.
>

An ENUM in postgres *is* an id + lookup table..

.m