Re: how is that possible

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: how is that possible
Date: 2006-02-10 16:59:51
Message-ID: 20060210085444.S20686@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Fri, 10 Feb 2006 ohp(at)pyrenet(dot)fr wrote:

> My understanding is that null or not, their 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Woodward 2006-02-10 17:16:04 Re: PostgreSQL 8.0.6 crash
Previous Message Tom Lane 2006-02-10 16:58:33 Re: Scrollable cursors and Sort performance