Re: How to add month.year column validation

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Andrus" <kobruleht2(at)hot(dot)ee>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Andy Shellam" <andy-lists(at)networkmail(dot)eu>
Subject: Re: How to add month.year column validation
Date: 2009-12-25 00:05:16
Message-ID: 200912241605.16988.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 24 December 2009 3:47:23 pm Andrus wrote:
> Scott,
>
> >You can use the regex I posted to get rid of the data easily, then go
> >back to the substr one for a check constraint after that.
>
> regex is non-standard.
> How to implement this in standard SQL ?
>
> Andrus.

Why should it matter? The initial data clean up is a one time event. Once the
fields are cleaned up the check constraint will keep them that way.

--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-12-25 00:56:26 Re: date_trunc on date is immutable?
Previous Message Andrus 2009-12-24 23:47:23 Re: How to add month.year column validation