Postgres Pro
Downloads
Home   >   mailing lists

Unique text index on a non-text column - Mailing list pgsql-admin

From Craig James
Subject Unique text index on a non-text column
Date
Msg-id CAFwQ8rdMObVzXTx4Uv-Wnws2aiLaibWm+ADrfActGVBPcT5RUA@mail.gmail.com
Whole thread Raw
Responses Re: Unique text index on a non-text column
List pgsql-admin
Tree view
I'd like to enforce text uniqueness on a non-text column (it's of type "molecule" from a third-party plugin). The third-party plugin doesn't support unique indexes. My guess was something like this, but it doesn't work:

create table molecules(id integer primary key, moltext molecule('my-type'));
create unique index i_unique_molecule on molecules(moltext::text);

The "molecule" column does contain an ordinary string, and when selected returns ordinary text data.

Is there a way to do this? (And if so, what did I miss in the documentation?)

Thanks,
Craig

pgsql-admin by date:

Previous
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: Create extension without superuser
Next
From: "David G. Johnston"
Date:
Subject: Re: Unique text index on a non-text column