Home > mailing lists

Re: Domain check constraint not honored? - Mailing list pgsql-general

From	Rob Sargent
Subject	Re: Domain check constraint not honored?
Date	October 30, 2015 02:16:22
Msg-id	5632A8BE.7040604@gmail.com Whole thread Raw
In response to	Re: Domain check constraint not honored? (Tom Lane <tgl@sss.pgh.pa.us>)
Responses	Re: Domain check constraint not honored?
List	pgsql-general

On 10/29/2015 05:01 PM, Tom Lane wrote:

Eric Schwarzenbach <subscriber@blackbrook.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.]+

From: Tom Lane
Date: 30 October 2015, 02:01:10
Subject: Re: Domain check constraint not honored?

From: David Blomstrom
Date: 30 October 2015, 03:18:17
Subject: Hierarchical Query Question (PHP)