Home > mailing lists

Re: Selecting strict, immutable text for a composite type. - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Selecting strict, immutable text for a composite type.
Date	May 11, 2018 00:41:53
Msg-id	CAKFQuwYUdwRL_PO_6fZ==-85obk=FAbv4wWDPJR+dw337m2PeQ@mail.gmail.com Whole thread Raw
In response to	Re: Selecting strict, immutable text for a composite type. (Steven Lembark <lembark@wrkhors.com>)
List	pgsql-general

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

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

Have you installed the btree-gist extension?

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

David J.

From: Tom Lane
Date: 11 May 2018, 00:38:48
Subject: Re: Selecting strict, immutable text for a composite type.

From: Adrian Klaver
Date: 11 May 2018, 00:55:19
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE