"Alejandro Michelin Salomon \( Adinet \)" <alejmsg@xxxxxxxxxxxxx> writes: > I need create a PK for a table. > This PK has 3 fields. > PK is : CONSTRAINT ff_navios PRIMARY KEY ( idempresa, idarmador, UPPER( nome > ) ) > But seems not work. You can't define a primary key on an expression. The SQL standard says so, and even if we wanted to generalize the standard here, we'd have a bit of a problem with how it'd show up in the information_schema. You can, however, create a unique index over those values and get pretty much the same effect. regards, tom lane
