Re: Alias to a type

Richard Huxton wrote:
> Veikko Mäkinen wrote:
>
>> 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.
>
>
> CREATE DOMAIN username_string AS varchar(20);
>
> Test it with your client applications though, make sure they cope. Some
> don't cope well with user-defined types.

Splendid, thank you all :) I'm quite sure loosely typed PHP can cope
with my user-defined types ;)

But now I need a better modeling tool because Azzurri Clay 1.1 (Eclipse
plug-in) doesn't let me define new types... Any suggestions? SQL DDL
generation is the only demand I really have.

-veikko