X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 20E1AD1E7DC; Mon, 19 Jan 2004 17:59:08 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 94305-09; Mon, 19 Jan 2004 13:58:37 -0400 (AST)
Received: from davinci.ethosmedia.com (server228.ethosmedia.com
	[209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP
	id B69C7D1E762; Mon, 19 Jan 2004 13:58:35 -0400 (AST)
Received: from [63.195.55.98] (HELO 192.168.1.29)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 4281913; Mon, 19 Jan 2004 09:59:37 -0800
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: "scott.marlowe" <scott.marlowe@ihs.com>,
	"Joshua D. Drake" <jd@commandprompt.com>
Subject: Re: New PostgreSQL search resource
Date: Mon, 19 Jan 2004 09:57:54 -0800
User-Agent: KMail/1.5.4
Cc: "'PostgreSQL General'" <pgsql-general@postgresql.org>,
	Postgresql Advocacy <pgsql-advocacy@postgresql.org>
References: <Pine.LNX.4.33.0401191037310.11187-100000@css120.ihs.com>
In-Reply-To: <Pine.LNX.4.33.0401191037310.11187-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200401190957.54350.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/265
X-Sequence-Number: 3447

Scott,

> "create unique index"
> 
> "select distinct"

I believe that one does this by adding to the word root dictionary and 
rebuilding the index.   The problem is that then anything indexed as "select 
distinct" shows up under searches for "select distinct" but not for 
"distinct".

Try searching on SELECT & DISTINCT

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco