RE: [GENERAL] Optimal indicies - Mailing list pgsql-general

From Remigiusz Sokolowski
Subject RE: [GENERAL] Optimal indicies
Date
Msg-id Pine.GS4.4.02A.9904211222380.22405-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to RE: [GENERAL] Optimal indicies  (Oleg Broytmann <phd@sun.med.ru>)
List pgsql-general
Btw. of indices:
is there a way to add to index boolean type?
I have a table from which I get records with clause where on four columns.
One is text, second is int and two other are bool.
I need to get data from this table in most effective way, but for now have
no indices cause when I try bool_ops type postgres returns error. I have
ver. 6.3.2 so I'm interested if may be in newer versions there is such
type or may be there are any workarounds?
    TIA
    Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------


pgsql-general by date:

Previous
From: Oleg Broytmann
Date:
Subject: RE: [GENERAL] Optimal indicies
Next
From: José Soares
Date:
Subject: Re: [GENERAL] Object-oriented stuff and postgres