IMHO null values shouldn't verify foreign keys constraints...
Gustavo.
2006/2/10, ohp@pyrenet.fr <ohp@pyrenet.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@megazone.bigpanda.com>
> > To: ohp@pyrenet.fr
> > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> > Subject: Re: [HACKERS] how is that possible
> >
> >
> > On Fri, 10 Feb 2006 ohp@pyrenet.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@pyrenet.fr
> ------------------------------------------------------------------------------
> Make your life a dream, make your dream a reality. (St Exupery)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>