Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5BEFB632B8A for ; Wed, 3 Mar 2010 12:21:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47499-02 for ; Wed, 3 Mar 2010 16:21:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sargon.lncsa.com (mail.lncsa.com [213.215.28.11]) by mail.postgresql.org (Postfix) with ESMTP id E5A2E633D9B for ; Wed, 3 Mar 2010 12:21:20 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 21B6D301E6E6 for ; Wed, 3 Mar 2010 17:21:20 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0fQMtyi9wqSp for ; Wed, 3 Mar 2010 17:21:20 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 03FE5300E35F for ; Wed, 3 Mar 2010 17:21:20 +0100 (CET) Received: from galba.apartia.fr (galba.apartia.fr [10.0.3.119]) by zenon.apartia.fr (Postfix) with ESMTP id B556E58A0DA30 for ; Wed, 3 Mar 2010 17:21:19 +0100 (CET) Received: by galba.apartia.fr (Postfix, from userid 1000) id 922711D42C; Wed, 3 Mar 2010 17:21:19 +0100 (CET) Date: Wed, 3 Mar 2010 17:21:19 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: check constraint on multiple tables? Message-ID: <20100303162119.GC22889@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20100303150227.GA18661@apartia.fr> <20100303160659.GA22889@apartia.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/23 X-Sequence-Number: 33730 On Wed, Mar 03, 2010 at 10:13:48AM -0600, Little, Douglas wrote: > Hey Louis, > > Ship rooms are just like Hotel rooms. There are lots of ways to > describe. But there needs to be some consistency between the > classifiers for them to have any meaning. > > A junior suite should mean the same thing regardless of the ship it's on. Not so simple, cruise lines like to slice and dice (segment in marketing speak) their offerings by creating ship-specific cabin types with (ever so slightly) different features and prices.