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:[EMAIL PROTECTED] |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 [EMAIL PROTECTED] so |that your | message can get through to the mailing list cleanly | ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster