Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 766B29FB37A for ; Sun, 27 May 2007 13:34:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 92933-06 for ; Sun, 27 May 2007 13:34:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 60E7B9FB374 for ; Sun, 27 May 2007 13:34:29 -0300 (ADT) Received: from mastermind.kaltenbrunner.cc ([83.215.233.60]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1HsLhF-0001tZ-CL; Sun, 27 May 2007 18:34:24 +0200 Message-ID: <4659B30E.5000802@kaltenbrunner.cc> Date: Sun, 27 May 2007 18:34:22 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: "Jim C. Nasby" CC: Chander Ganesan , pgsql-performance@postgresql.org Subject: Re: Domains versus Check Constraints References: <465320B5.7050305@otg-nc.com> <20070527155942.GN92628@nasby.net> In-Reply-To: <20070527155942.GN92628@nasby.net> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/564 X-Sequence-Number: 24954 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