You probably should define your domain like this:
CREATE DOMAIN myvarchar varchar(42);
On Sat, Feb 15, 2014 at 6:23 PM, James Harper <james.harper@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
