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)