Re: Domains (Was [PERFORM] Views With Unions) - Mailing list pgsql-general

From Francisco J Reyes
Subject Re: Domains (Was [PERFORM] Views With Unions)
Date
Msg-id 20030802142257.S99004@zoraida.natserv.net
Whole thread Raw
In response to Re: Domains (Was [PERFORM] Views With Unions)  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-general
On Sat, 2 Aug 2003, Jochem van Dieten wrote:

> Francisco J Reyes wrote:
> > Are domains user defined types? That they seem to be based on what I see
> > on the docs.
>
> They are similar a bit to user defined types,
......
>
> Please note that the SQL:1999 concept of user defined types is
> quite different from the one in PostgreSQL (in his book "Advanced
> SQL:1999" Jim Melton even warns that domains may be deprecated in
> future SQL standards in favour of SQL-style user defined types).


Thanks for the explanation and the warning. Based on your feedback, don't
quite see how domains would be usefull to me so I will not use them for
now.

pgsql-general by date:

Previous
From: Francisco J Reyes
Date:
Subject: Re: Inheritance vs child tables (Was Domains)
Next
From: Joseph Shraibman
Date:
Subject: like performance w/o wildcards.