Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A03609FB6E8 for ; Tue, 22 May 2007 13:56:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56447-06 for ; Tue, 22 May 2007 13:56:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp110.iad.emailsrvr.com (smtp110.iad.emailsrvr.com [207.97.245.110]) by postgresql.org (Postfix) with ESMTP id 8CE4B9FB68B for ; Tue, 22 May 2007 13:56:23 -0300 (ADT) Received: from [10.0.2.11] (adsl-074-239-169-041.sip.rmo.bellsouth.net [74.239.169.41]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: chander@otg-nc.com) by relay1.r1.iad.emailsrvr.com (SMTP Server) with ESMTP id 8B11C44EACB for ; Tue, 22 May 2007 12:56:22 -0400 (EDT) Message-ID: <465320B5.7050305@otg-nc.com> Date: Tue, 22 May 2007 12:56:21 -0400 From: Chander Ganesan User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Domains versus Check Constraints Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/440 X-Sequence-Number: 24830 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