Re: [DOCS] [PATCHES] Caveat for Domains
David Fetter wrote: On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote: Patch applied. Thanks. Could you please put fixing domains for functions on the TODO list? Added to TODO: * Allow user-defined functions retuning a domain value to enforce domain constraints --- Cheers, D --- David Fetter wrote: 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! [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: explain analyze is your friend -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] Caveat for Domains
On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote: Patch applied. Thanks. Could you please put fixing domains for functions on the TODO list? Cheers, D --- David Fetter wrote: 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! [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: explain analyze is your friend -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PATCHES] Caveat for Domains
Patch applied. Thanks. --- David Fetter wrote: 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! [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: explain analyze is your friend
[PATCHES] Caveat for Domains
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 - 1.22 --- doc/src/sgml/ref/create_domain.sgml 9 Sep 2005 21:21:39 - *** *** 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. noteKeep 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 6: explain analyze is your friend