Re: Domain check constraint not honored?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Domain check constraint not honored?
Date: 2015-10-29 23:16:14
Message-ID: 5632A8BE.7040604@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/29/2015 05:01 PM, Tom Lane wrote:
> Eric Schwarzenbach <subscriber(at)blackbrook(dot)org> writes:
>> ... (Also FWIW, the latest version of
>> this regexp is now '^([0-9]+.)*[0-9]+$')
> Um, that's not gonna do what you want at all. Outside brackets, a dot
> is a wildcard. (Regex syntax is a mess :-(.)
>
> regards, tom lane
>
>
arg. back to level two of regexpness for me :( I read it as ^[0-9.]+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Blomstrom 2015-10-30 00:18:13 Hierarchical Query Question (PHP)
Previous Message Tom Lane 2015-10-29 23:01:01 Re: Domain check constraint not honored?