Keep in mind, though. Using a DOMAIN in some definition 'seals' the domain.
Yo can't change the domain unless you drop all dependent objects
|-----Original Message-----
|From: Veikko Mäkinen [mailto:veikko.makinen@ecom.fi]
|Sent: Mittwoch, 22. Juni 2005 15:14
|To: pgsql-sql@postgresql.org
|Subject: Re: [SQL] 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
|
|
|---------------------------(end of
|broadcast)---------------------------
|TIP 3: if posting/reading through Usenet, please send an appropriate
| subscribe-nomail command to majordomo@postgresql.org so
|that your
| message can get through to the mailing list cleanly
|