Re: Selecting strict, immutable text for a composite type.

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, May 10, 2018 at 2:16 PM, Steven Lembark <lembark@xxxxxxxxxxx> wrote:

    exclude using gist
    (
        location    using =,
        effective   using &&
    )

Have you installed the btree-​gist extension?

https://www.postgresql.org/docs/10/static/btree-gist.html

Not sure about composites but if you do store a text representation it will work.

David J.