| From: | "Alejandro Michelin Salomon \( Adinet \)" <alejmsg(at)adinet(dot)com(dot)uy> |
|---|---|
| To: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | PK with an expression in field list |
| Date: | 2006-05-24 14:55:12 |
| Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAhx491Ki2tUS42D/aMPFg1MKAAAAQAAAAF/Z2oXHDKEuLTgKLcD9yywEAAAAA@adinet.com.uy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi:
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.
I have and other way to do this ?
If this fields are not null and i create a unique index in place off pk, i
have the same effect ?
Alejandro Michelin Salomon
Porto Alegre
Brasil.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.0/346 - Release Date: 23/5/2006
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 143 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sim Zacks | 2006-05-24 15:17:03 | Re: background triggers? |
| Previous Message | Rafal Pietrak | 2006-05-24 14:54:03 | Re: background triggers? |