| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | Veikko Mäkinen <veikko(dot)makinen(at)ecom(dot)fi>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Alias to a type |
| Date: | 2005-06-22 12:04:39 |
| Message-ID: | af9f545f8a3ab4a09d90b2d589443a49@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Jun 22, 2005, at 7:42 AM, Achilleus Mantzios wrote:
> O Veikko Mδkinen έγραψε στις Jun 22, 2005 :
>
>> Hey,
>>
>> Is it possible to create a new type as an alias to a pre-defined
>> type? I
>> use "USERID varchar(20)" in almost every table I have I'd like to make
>> an alias for that type eg.
>>
>> <pseudo-sql>
>> create type myschema.useridtype as varchar(20);
>> </pseudo-sql>
>>
>
> Try something like
>
> CREATE DOMAIN my_integer AS INTEGER;
Just for my own edification, does creating a "simple" domain like this
then require a whole set of functions for indexing, etc., like other
more complex user-defined types, or will postgres "do the right thing"?
Thanks,
Sean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-22 12:07:01 | Re: Alias to a type |
| Previous Message | Achilleus Mantzios | 2005-06-22 11:42:20 | Re: Alias to a type |