Re: Trying to add a type modifier to user created type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yeb Havinga <yebhavinga(at)gmail(dot)com>
Cc: Carsten Kropf <ckropf2(at)fh-hof(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Trying to add a type modifier to user created type
Date: 2010-02-18 15:46:46
Message-ID: 20518.1266508006@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-02-18 15:48:50 Re: SQL select return into PSQL variables.
Previous Message Tom Lane 2010-02-18 15:42:05 Re: errmsg and multi-byte strings.