Re: Is CREATE TYPE an alias for CREATE DOMAIN?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Is CREATE TYPE an alias for CREATE DOMAIN?
Дата
Msg-id 20051228170925.GD72143@pervasive.com
обсуждение исходный текст
Ответ на Re: Is CREATE TYPE an alias for CREATE DOMAIN?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Is CREATE TYPE an alias for CREATE DOMAIN?  (John Dean <john@totalrekall.co.uk>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: sending mail from Postgres
Следующее
От: Dmitry Panov
Дата:
Сообщение: Re: WAL logs multiplexing?