question

[Alexandr S]

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?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Alexandr S <sa***@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match