repost: unique composite index with boolean fields

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-general(at)postgreSQL(dot)org
Subject: repost: unique composite index with boolean fields
Date: 1999-08-10 17:30:31
Message-ID: Pine.BSF.4.05.9908102129300.15954-100000@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello there,

Could anybody advise me how can I create composite index for table when
one of key fields is of boolean type?

Schema is as follows:

create table test (indoor bool, pos int, name varchar(64) NOT NULL,
check (pos >= 0 and pos <=32000));

create unique index test_pkey on test (indoor, pos);

leads to error
ERROR: Can't find a default operator class for type 16.

Finally, I use char_ops as type class:

create unique index test_pkey on test (indoor char_ops, pos);

-- is it correct?

Sincerely,
D.Marck [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Morozovsky 1999-08-10 17:39:03 Re: [GENERAL] ALTER TABLE
Previous Message Wim Kerkhoff 1999-08-10 15:49:31 Re: [GENERAL] Selecting between dates