Re: Postgres vr.s MySQL- style differences?

[Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>]

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