question - Mailing list pgsql-general

From Alexandr S
Subject question
Date
Msg-id 3FA673E1.7010302@in.crimea.ua
Whole thread Raw
Responses Re: question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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?



pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Fixed field text import
Next
From: "scott.marlowe"
Date:
Subject: Re: Cartesian product bug?