Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 50CEB633707 for ; Thu, 7 Jan 2010 23:44:33 -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 33305-04 for ; Fri, 8 Jan 2010 03:44:22 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id CECEA632A0A for ; Thu, 7 Jan 2010 23:44:22 -0400 (AST) Received: from list by lo.gmane.org with local (Exim 4.50) id 1NT5lr-00058i-Rx for pgsql-sql@postgresql.org; Fri, 08 Jan 2010 04:44:20 +0100 Received: from s01060015e975d7fb.wp.shawcable.net ([24.77.73.195]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Jan 2010 04:44:19 +0100 Received: from spluque by s01060015e975d7fb.wp.shawcable.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Jan 2010 04:44:19 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Seb Subject: Re: Fwd: conditional rule not applied Date: Thu, 07 Jan 2010 21:43:57 -0600 Organization: Church of Emacs Lines: 24 Message-ID: <87y6k9gt1e.fsf@kolob.sebmags.homelinux.org> References: <87fx6jm0fl.fsf@kolob.sebmags.homelinux.org> <4B45FE51.3030004@beecom.ch> Mime-Version: 1.0 Content-Type: text/plain X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: s01060015e975d7fb.wp.shawcable.net User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) Cancel-Lock: sha1:ENqRyeCv333D3/6Ru6NuT6rI/Zg= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.589 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188 X-Spam-Level: X-Archive-Number: 201001/10 X-Sequence-Number: 33546 On Thu, 07 Jan 2010 16:31:29 +0100, Leo Mannhart wrote: [...] > I can give a 'first cut' solution. But I strongly discourage from > doing this in a real world application as chances are big, that you'll > forget something to implement correctly (nullable fields come to mind > immediately as an example). Your example is also simplified as it > makes no sense for instance, that sh_name is nullable... > here we go: [...] Thank you very much for your time on this. I can see that this is indeed a difficult thing to implement. I'll study your code carefully to understand the issues a little better. Cheers, -- Seb