Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-08-02 Thread Jim Seymour
Janning Vygen <[EMAIL PROTECTED]> wrote: > [snip] > > 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 ext

Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-08-02 Thread Janning Vygen
Am Samstag, 31. Juli 2004 17:13 schrieb Tom Lane: > Janning Vygen <[EMAIL PROTECTED]> 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 > col

Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-07-31 Thread Tom Lane
Janning Vygen <[EMAIL PROTECTED]> 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 primar