From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Alias to a type |
Date: | 2005-06-22 14:42:19 |
Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB1678C@neptun.sonorys.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)makinen(at)ecom(dot)fi]
|Sent: Mittwoch, 22. Juni 2005 15:14
|To: pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org so
|that your
| message can get through to the mailing list cleanly
|
From | Date | Subject | |
---|---|---|---|
Next Message | Russell Simpkins | 2005-06-22 16:06:54 | after delete trigger behavior |
Previous Message | Veikko Mäkinen | 2005-06-22 13:14:09 | Re: Alias to a type |