From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
---|---|
To: | Eric Schwarzenbach <subscriber(at)blackbrook(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Domain check constraint not honored? |
Date: | 2015-10-30 13:53:25 |
Message-ID: | 56337655.3060500@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/29/15 5:29 PM, Eric Schwarzenbach wrote:
> I'm just now converting that path to use a custom domain (along with
> custom operators) instead of just being a string. (The custom operators
> allow the paths to be sorted properly without each segment needing to be
> filled with zeros to a fixed length.) (Also FWIW, the latest version of
> this regexp is now '^([0-9]+.)*[0-9]+$')
Have you looked at using int[]? It wouldn't be hard to go between that
and the string representation using string_to_array() and
array_to_string(). There's also a chance that eventually you'd be able
to do FKs on it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dane Foster | 2015-10-30 14:21:10 | Re: mysql_fdw trouble |
Previous Message | Adrian Klaver | 2015-10-30 13:53:15 | Re: ftell mismatch with expected position |