Postgres Pro
Downloads
Home   >   mailing lists

Re: type aliases - Mailing list pgsql-general

From Behrang Saeedzadeh
Subject Re: type aliases
Date
Msg-id CAERAJ+-S32yxS0yROo6ME+D4kwGhF3JktpigynvK=wnpViB5gQ@mail.gmail.com
Whole thread Raw
In response to type aliases  (James Harper <james.harper@bendigoit.com.au>)
Responses Re: type aliases  (James Harper <james.harper@bendigoit.com.au>)
List pgsql-general
Tree view
You probably should define your domain like this:

   CREATE DOMAIN myvarchar varchar(42);

Best regards,
Behrang


On Sat, Feb 15, 2014 at 6:23 PM, James Harper <james.harper@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

pgsql-general by date:

Previous
From: James Harper
Date:
Subject: type aliases
Next
From: James Harper
Date:
Subject: Re: type aliases