Re: How to use as Functional Index to be used as Primary KEY - Mailing list pgsql-general

Janning Vygen <vygen@gmx.de> writes:
> So here is my question: How can i define a functional index to be used
> with a primary key (using postgreSQL 7.4.3)?

You can't.  The SQL spec says that primary keys are columns or lists of
columns.

I don't see any particular difference between a primary key and a unique
index, anyway, except that the primary key is the default target for
foreign-key references.

            regards, tom lane