Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-29 Thread John Dean
Hi Jim I have checked through the docs for:- 1. Interbase/Firebird 2. Sybase/MS SQL Server 3. Oracle 4. DB2 5. PostgreSQL BTW I didn't bother to check the MySQL docs because I do not consider MySQL to be a RDBMS It seems that only Interbase/Firebird and PostgreSQL supports the CREATE DOMAIN s

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-28 Thread Jim C. Nasby
On Thu, Dec 22, 2005 at 05:16:16PM +0100, Peter Eisentraut wrote: > Jim C. Nasby wrote: > > Some (most?) database's idea of 'creating a type' is actually what we > > consider creating a domain, > > Which databases do such a thing? IIRC, Oracle, DB2, Sybase and MSSQL, though my memory's rusty... a

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-22 Thread Peter Eisentraut
Jim C. Nasby wrote: > Some (most?) database's idea of 'creating a type' is actually what we > consider creating a domain, Which databases do such a thing? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5:

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-22 Thread Bruce Momjian
Jim C. Nasby wrote: > On Thu, Dec 22, 2005 at 09:36:52AM +, Richard Huxton wrote: > > John Dean wrote: > > >Hi > > > > > >Could somebody please tell me if CREATE TYPE is equivalent to CREATE > > >DOMAIN? If not is there a work around > > > > What do you mean by "equivalent"? You wouldn't use

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-22 Thread Jim C. Nasby
On Thu, Dec 22, 2005 at 09:36:52AM +, Richard Huxton wrote: > John Dean wrote: > >Hi > > > >Could somebody please tell me if CREATE TYPE is equivalent to CREATE > >DOMAIN? If not is there a work around > > What do you mean by "equivalent"? You wouldn't use them in the same way, > and I'm not

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-22 Thread Richard Huxton
John Dean wrote: Hi Could somebody please tell me if CREATE TYPE is equivalent to CREATE DOMAIN? If not is there a work around What do you mean by "equivalent"? You wouldn't use them in the same way, and I'm not sure what a work-around would consist of. What are you trying to do? -- Ric

[GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-22 Thread John Dean
Hi Could somebody please tell me if CREATE TYPE is equivalent to CREATE DOMAIN? If not is there a work around --- Regards John Dean, co-author of Rekall, the only alternative to MS Access ---(end of broadcast)--- TIP 6: explain analyze is y