RE: [GENERAL] Optimal indicies

From: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
To: phd2(at)earthling(dot)net
Cc: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>, PostgreSQL <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] Optimal indicies
Date: 1999-04-21 10:28:28
Message-ID: Pine.GS4.4.02A.9904211222380.22405-100000@netra.gdansk.sprint.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message José Soares 1999-04-21 12:42:03 Re: [GENERAL] Object-oriented stuff and postgres
Previous Message Oleg Broytmann 1999-04-21 08:54:19 RE: [GENERAL] Optimal indicies