Re: [PERFORM] Domains versus Check Constraints

2007-05-27 Thread Stefan Kaltenbrunner
Jim C. Nasby wrote: > On Tue, May 22, 2007 at 12:56:21PM -0400, Chander Ganesan wrote: >> Are there any performance improvements that come from using a domain >> over a check constraint (aside from the ease of management component)? > > No. Plus support for domain constraints isn't universal (plp

Re: [PERFORM] Domains versus Check Constraints

2007-05-27 Thread Jim C. Nasby
On Tue, May 22, 2007 at 12:56:21PM -0400, Chander Ganesan wrote: > Are there any performance improvements that come from using a domain > over a check constraint (aside from the ease of management component)? No. Plus support for domain constraints isn't universal (plpgsql doesn't honor them, for

[PERFORM] Domains versus Check Constraints

2007-05-22 Thread Chander Ganesan
Are there any performance improvements that come from using a domain over a check constraint (aside from the ease of management component)? thanks -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 -