[Fwd: Re: PG rules! (RULES being the word ;->)]

By the way,

If anyone's interested I just wrote that intro to rules up into an
article on the techdocs.postgresql.org site :

http://techdocs.postgresql.org/techdocs/intropostgresqlrules.php

:-)

Regards and best wishes,

Justin Clift


Dr. Evil wrote :
> That's pretty cool.  I may look into those.  I just like being able
> to define that the data stay in a self-consistent format.  Other
> programming languages would do well to follow this method.  I'm
> programming my front-end in PHP.  I should be able to say
>
> INT i CHECK (i > 0);
>
> when I declare it in PHP, for instance, but this isn't possible;
> they don't even have strong typing!
>
> Anyway, I was just writing a table which holds credit card payment
> data.  I put in a constraint:
>
>        cardnumber VARCHAR(20) CHECK (luhn10(cardnumber)),
>
> right in the table, so no matter how screwed up anything is, only
> valid card numbers can go in the table.