Re: Alias to a type - Mailing list pgsql-sql

From KÖPFERL Robert
Subject Re: Alias to a type
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB1678C@neptun.sonorys.at
Whole thread Raw
In response to Alias to a type  (Veikko Mäkinen <veikko.makinen@ecom.fi>)
List 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.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
|


pgsql-sql by date:

Previous
From: Veikko Mäkinen
Date:
Subject: Re: Alias to a type
Next
From: "Russell Simpkins"
Date:
Subject: after delete trigger behavior