From: Richard Huxton <dev@archonet.com>
To: Joe Conway <mail@joeconway.com>
Subject: Re: Scalar in a range (but textual not numeric)
Date: Wed, 25 Feb 2004 22:10:47 +0000
User-Agent: KMail/1.5
Cc: pgsql-sql@postgresql.org
References: <200402251918.20289.dev@archonet.com>
	<200402252036.40747.dev@archonet.com>
	<403D0C0B.2040507@joeconway.com>
In-Reply-To: <403D0C0B.2040507@joeconway.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200402252210.47496.dev@archonet.com>

On Wednesday 25 February 2004 20:56, Joe Conway wrote:
> Richard Huxton wrote:
> > That's not quite the same though, because it means I need to split
> > ABCAA..ABDBB into ABCAA..ABCZZ and ABDAA..ABDZZ but it's close enough
> > unless someone is feeling clever this evening.
>
> Would (a series of) partial indexes help?

Not here - it's the irritation of splitting my single range into two at some 
arbitrary boundary that bugs me with this solution.

Ah well - if it was that straightforward, I wouldn't be able to charge for it.

Thanks Joe
-- 
  Richard Huxton
  Archonet Ltd