| From: | Carsten Kropf <ckropf2(at)fh-hof(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Trying to add a type modifier to user created type |
| Date: | 2010-02-18 16:22:31 |
| Message-ID: | 79A1438B-ADC9-4485-8D8D-AFD0B6A71589@fh-hof.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks a lot so far, got it working with the cast. Probably the documentation about create type where the type modifiers are described should be extended in order to find that.
Thanks and regards
Carsten Kropf
Am 18.02.2010 um 16:46 schrieb Tom Lane:
> Yeb Havinga <yebhavinga(at)gmail(dot)com> writes:
>> Carsten Kropf wrote:
>>> I wanted to add a new type that supports modifiers (comparable to
>>> numeric/varchar).
>
>> You need to add a cast from the type to itself, e.g.
>
> The CREATE CAST reference page has the gory details here.
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Barnes | 2010-02-18 17:20:56 | Setting a table to be ignored by autovacuum |
| Previous Message | Vick Khera | 2010-02-18 15:48:50 | Re: SQL select return into PSQL variables. |