Обсуждение: question

Hi
There is question. How can I  set column varchar[]  (array) as UNIQUE
(constraint)? (I need this to set foreign key, but for this to work
varchar[]  must be primary key or unique).
I use pgadmin, and pgadmin answer: "Error: data type character varying[]
has no default operator class for access method "btree". You must
specify an operator class for the index or define a default operator
class for the data type"           What should I do?

Alexandr S <sasha@in.crimea.ua> writes:
> There is question. How can I  set column varchar[]  (array) as UNIQUE

You cannot, in any Postgres version before 7.4.  There isn't support for
indexes on array columns before 7.4.

            regards, tom lane