Postgres Pro
Downloads
Home   >   mailing lists

Re: Is CREATE TYPE an alias for CREATE DOMAIN? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Is CREATE TYPE an alias for CREATE DOMAIN?
Date
Msg-id 20051228170925.GD72143@pervasive.com
Whole thread Raw
In response to Re: Is CREATE TYPE an alias for CREATE DOMAIN?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Is CREATE TYPE an alias for CREATE DOMAIN?
List pgsql-general
Tree view 
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... and I
should have mentioned that most are just creating an alias for a type
name, so you can't add stuff like constraints to the new type.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: sending mail from Postgres
Next
From: Dmitry Panov
Date:
Subject: Re: WAL logs multiplexing?