Re: Postgres vr.s MySQL- style differences?

David Fetter wrote:
> On Tue, May 29, 2007 at 07:26:51PM +0200, Lukas Kahwe Smith wrote:
>> Jim Nasby wrote:
>>
>>>> Yup, the tend to heavily rely on data integrity management on the
>>>> middle tier. Which by the way is not totally crazy, because you
>>>> need most of the data integrity rules on the frontend anyways, to
>>>> generate proper GUI's. Actually in non object-relational RDBMS
>>>> (which are the norm, PostgreSQL is special), you can never do your
>>>> full integrity management inside the database.
>>> Can you give an example of that, because I can't think of one,
>>> unless you're talking about integrity that has to lie outside the
>>> database (ie: if you're storing filesystem locations in the
>>> database).
>> Yes, but more trivially since like "is this a valid email address"
>
> This is where PostgreSQL really shines. You can create a DOMAIN
> constraint that checks whether an address is valid all the way up to
> checking whether it's accepted for delivery, although I'd imagine you
> wouldn't want to do that last. You can then use that DOMAIN all over
> your code.

I know! I know!
/me hugs PostgreSQL

Actually while thinking of an example for my previous post I simply used
the "email validation" example from Roberts pl/php talk.

regards,
Lukas