Re: adding support for zero-attribute unique/etc keys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: adding support for zero-attribute unique/etc keys
Date
Msg-id 11040.1364218060@sss.pgh.pa.us
Whole thread Raw
In response to Re: adding support for zero-attribute unique/etc keys  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-hackers
Albe Laurenz <laurenz.albe@wien.gv.at> writes:
> Darren Duncan wrote:
>> I propose that this be generalized so that constraints may instead be nullary,
>> that is, range over zero or more attributes/columns instead.

> Since an imagined zero-column query would have an empty set of
> result columns, you could with equal force argue that these columns
> satisfy the condition or not, because the members of the empty
> set have all the properties you desire.

The semantics of a zero-column foreign key seem even less well
defined.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Enabling Checksums
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)