Re: how is that possible
От | ohp@pyrenet.fr |
---|---|
Тема | Re: how is that possible |
Дата | |
Msg-id | Pine.UW2.4.53.0602102107310.17590@sun.pyrenet обсуждение исходный текст |
Ответ на | Re: how is that possible (Stephan Szabo <sszabo@megazone.bigpanda.com>) |
Ответы |
Re: how is that possible
|
Список | pgsql-hackers |
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)
В списке pgsql-hackers по дате отправления: