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
Msg-id CAKFQuway0Ou49jvzNv_Wpe_zT-yNp5Tuu6JucKsSGb5UKeXBYg@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 Thursday, May 10, 2018, Steven Lembark <lembark@wrkhors.com> wrote:
Q: Why does it work with enums?

Guessing because enums are not composites; they are scalar and most scalar types in core seem to be covered by the extension.
 
e.g., If I create a type foo_t as enum (...) and install the function
foo_text on foo_t the gist works. 

You should ifnd it works even without the existence of the foo_text function.

David J.

pgsql-general by date:

Previous
From: Steven Lembark
Date:
Subject: Re: Selecting strict, immutable text for a composite type.
Next
From: Ben Hood
Date:
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE