Received: from ns.infoset.cz (ns.infoset.cz [194.213.32.210]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA18896 for ; Wed, 22 Sep 1999 14:59:48 -0400 (EDT) (envelope-from dpeder@infoset.cz) Received: from WinProxy.anywhere ([62.168.15.178]) by ns.infoset.cz (8.8.7/8.8.7) with SMTP id VAA17918 for ; Wed, 22 Sep 1999 21:03:07 +0200 Received: from 192.168.1.1 by 192.168.1.3 (WinProxy); Wed, 22 Sep 1999 20:52:34 +0100 Received: by Dan with Microsoft Mail id <01BF053C.2E0ACE60@Dan>; Wed, 22 Sep 1999 20:51:01 +0200 Message-ID: <01BF053C.2E0ACE60@Dan> From: =?iso-8859-2?Q?Daniel_P=E9der?= To: "'pgsql-sql@postgresql.org'" Subject: partial indexes (indices) PostgreSQL 6.3.2 / 6.5.1 Date: Wed, 22 Sep 1999 20:51:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id PAA19240 I need to use partial indexes are they implemented in versions 6.3.2 / 6.5.1 ? if they are, what's the syntax example: table: grp ... name A ... john A ... george B ... susan B ... mary how to create partial index to have seperately indexed groups A and B eg grp='B' === what it should be good for ? I have large table wich is usualy beeng looked up by simple groups. So I need to save resources having the groups "pre-selected". And, however, sometimes beeing able to lookup the whole table. dan