Re: how is that possible

IMHO null values shouldn't verify foreign keys constraints...

Gustavo.

2006/2/10, ohp(at)pyrenet(dot)fr <ohp(at)pyrenet(dot)fr>:
> Many thanks for explaining.
> I learned something today...
>
> On Fri, 10 Feb 2006, Stephan Szabo wrote:
>
> > Date: Fri, 10 Feb 2006 08:59:51 -0800 (PST)
> > From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
> > To: ohp(at)pyrenet(dot)fr
> > Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> > Subject: Re: [HACKERS] how is that possible
> >
> >
> > On Fri, 10 Feb 2006 ohp(at)pyrenet(dot)fr wrote:
> >
> > > My understanding is that null or not, there should have been a foreign
> key
> > > violation.
> >
> > Not as far as I can tell. MATCH (without partial or full) returns true if
> > any column in the row value constructor is NULL. MATCH FULL returns true
> > if all columns in the row value constructor are NULL and returns false if
> > it's a mix of NULLs and non-NULLs.
> >
> >
>
> --
> Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
> 15, Chemin des Monges +33-5-61-50-97-01 (Fax)
> 31190 AUTERIVE +33-6-07-63-80-64 (GSM)
> FRANCE Email: ohp(at)pyrenet(dot)fr
> ------------------------------------------------------------------------------
> Make your life a dream, make your dream a reality. (St Exupery)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>