Re: type aliases

You probably should define your domain like this:

CREATE DOMAIN myvarchar varchar(42);

Best regards,
Behrang
http://www.behrang.org

On Sat, Feb 15, 2014 at 6:23 PM, James Harper <james(dot)harper(at)bendigoit(dot)com(dot)au
> wrote:

> I can create an alias of a type like:
>
> CREATE DOMAIN myvarchar varchar;
>
> But I can't declare a myvarchar with a variable size, eg "mycolumn
> myvarchar(42)" and from what I've read this is the way it DOMAIN is
> supposed to work so I can't do it that way.
>
> Is there a way to define myvarchar the way I want to? Can I use CREATE
> TYPE and just mirror the declaration of the underlying type?
>
> Thanks
>
> James
>
>
>
> --
> 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
>