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
