Re: how is that possible

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)