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.har...@bendigoit.com.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
