Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0B8209F95FD for ; Wed, 3 Oct 2007 11:40:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 93488-07 for ; Wed, 3 Oct 2007 11:40:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.224]) by postgresql.org (Postfix) with ESMTP id E42D99F960C for ; Wed, 3 Oct 2007 11:40:37 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so1522891wri for ; Wed, 03 Oct 2007 07:40:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=aQQiwxeKWqKboQpFGVnVi3R2nPiawlH6UEZ8j852hFI=; b=LOVqYFiW+Q62GiTLKU9xctLu6VVll4LboRIouwy0us33IzTunB44iC/D1oAu7dyzxqFmfOTw15Pj18oCtUBiZ6/UNIbGeyH5ME6tTvcdnho5UtTuCV+e+HnUBb4LlGY9ij8We9oI2mfcjsqcbBa2ac6TrNgK4gRW+OUlzR3pZqE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OX/cNF2n+H2cDNj5DvOcJtmGGNNssyF6LiwCfeCK2gWIfkCvb7zfB1EhYGk/1lA5+7aFni3qdGgAQOWGt61r/IN+yznKybmaaHBUi31mJTH/+ziA5aBl0LHgcSegd5mPDncjD3WJiTreKEquvia0QzTOSZpUbetKrlELLFCaXrs= Received: by 10.142.157.15 with SMTP id f15mr786964wfe.1191422435103; Wed, 03 Oct 2007 07:40:35 -0700 (PDT) Received: by 10.142.241.3 with HTTP; Wed, 3 Oct 2007 07:40:35 -0700 (PDT) Message-ID: <92869e660710030740j238eca69n24a9d1febc40df63@mail.gmail.com> Date: Wed, 3 Oct 2007 15:40:35 +0100 From: "=?UTF-8?Q?Filip_Rembia=C5=82kowski?=" To: pgsql-sql@postgresql.org Subject: Re: Finding broken regex'es In-Reply-To: <758d5e7f0710030636m63bec244paa6cbaf04e66b3d2@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071002202313.GB18506@nibiru.local> <758d5e7f0710030636m63bec244paa6cbaf04e66b3d2@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/11 X-Sequence-Number: 29383 2007/10/3, Dawid Kuroczko : > CREATE TABLE rx_check ( > rx text CHECK ('' ~ rx IN ('t','f')) > ); wow. This is beautiful :)