Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to add a type modifier to user created type - Mailing list pgsql-general

From Tom Lane
Subject Re: Trying to add a type modifier to user created type
Date
Msg-id 20518.1266508006@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trying to add a type modifier to user created type  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: Trying to add a type modifier to user created type  (Carsten Kropf <ckropf2@fh-hof.de>)
List pgsql-general
Tree view 
Yeb Havinga <yebhavinga@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: errmsg and multi-byte strings.
Next
From: Vick Khera
Date:
Subject: Re: SQL select return into PSQL variables.