Folks,
I think this needs to be made explicit in the documentation. Better,
of course, would be some kind of change to the PL infrastructure that
Just Handles It, but until then....
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/ref/create_domain.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/create_domain.sgml,v
retrieving revision 1.22
diff -c -r1.22 create_domain.sgml
*** doc/src/sgml/ref/create_domain.sgml 2 May 2005 01:52:50 -0000 1.22
--- doc/src/sgml/ref/create_domain.sgml 9 Sep 2005 21:21:39 -0000
***************
*** 48,57 ****
</para>
<para>
! Domains are useful for abstracting common fields between tables into
! a single location for maintenance. For example, an email address column
may be used
! in several tables, all with the same properties. Define a domain and
! use that rather than setting up each table's constraints individually.
</para>
</refsect1>
--- 48,60 ----
</para>
<para>
! Domains are useful for abstracting common fields between tables
! into a single location for maintenance. For example, an email address
! column may be used in several tables, all with the same properties.
! Define a domain and use that rather than setting up each table's
! constraints individually. <note>Keep in mind also that declaring a
! function result value as a domain is pretty dangerous, because none of
! the PLs enforce domain constraints on their results.</note>
</para>
</refsect1>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org