| From: | Dmitry Morozovsky <marck(at)rinet(dot)ru> |
|---|---|
| To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] repost: unique composite index with boolean fields |
| Date: | 1999-08-11 15:32:42 |
| Message-ID: | Pine.BSF.4.05.9908111930410.24849-100000@woozle.rinet.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 11 Aug 1999, Herouth Maoz wrote:
HM> > Could anybody advise me how can I create composite index for table when
HM> > one of key fields is of boolean type?
HM>
HM> Which version of PostgreSQL do you have? I'm not sure about 6.5, but in
HM> 6.4.2 type "bool" was not indexable.
Well, at least when I use 'char_ops' as a comparator, index HAS been
created and SEEMS to be workable -- but i've got no time to test it
thoroughly...
Just to remind: my solution was
'create unique index t_idx on t (intfield, boolfield char_ops);'
Sincerely,
D.Marck [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Moreda | 1999-08-11 16:31:12 | How to manage processes in the backend? |
| Previous Message | Dr. Nisai Wanakule | 1999-08-11 14:56:45 | psql hangs for database > 2GB |