Обсуждение: Domains versus Check Constraints

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

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 example).
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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 (plpgsql doesn't
> honor them, for example).

since 8.2 domain constraints are enforced everywhere ...


Stefan