jseymour@linxnet.com (Jim Seymour) writes:
> Janning Vygen <vygen@gmx.de> wrote:
>> Thanks to Tom and Peter for your answers. I will design my table without a
>> primary key and use my unique index instead of a primary key. As this unique
>> key is the same as a primary key i dont see the reason why postgresql
>> should't extend the specs and allow functional primary key indizes.
> Because, as Tom Lane wrote: "The SQL spec says that primary keys are
> columns or lists of columns." Unlike some other SQL RDBMs, PostgreSQL
> at least *tries* (mostly) to be SQL standards compliant.
Or at least we try to pick our extensions carefully ;-). I don't see
the point of this one ...
regards, tom lane