Re: How to add month.year column validation

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Andy Shellam" <andy-lists(at)networkmail(dot)eu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to add month.year column validation
Date: 2009-12-24 23:47:23
Message-ID: 2208EA8968E848FA980690F51B095280@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-12-25 00:05:16 Re: How to add month.year column validation
Previous Message Kian Wright 2009-12-24 23:36:49 date_trunc on date is immutable?