Horton
Menu

RE: [GENERAL] Optimal indicies

Remigiusz Sokolowski <rems@gdansk.sprint.pl>

View thread
From: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
To: phd2@earthling.net
Cc: "Jackson, DeJuan" <djackson@cpsgroup.com>, PostgreSQL <pgsql-general@postgreSQL.org>
Date: 1999-04-21T10:28:28Z
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@gdansk.sprint.pl           * *		
-----------------------------------------------------------------*****----------