Skip site navigation (1) Skip section navigation (2)

Re: Scalar in a range (but textual not numeric)

From: Richard Huxton <dev(at)archonet(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Scalar in a range (but textual not numeric)
Date: 2004-02-25 22:10:47
Message-ID: 200402252210.47496.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-02-25 22:32:28
Subject: Re: Scalar in a range (but textual not numeric)
Previous:From: Richard HuxtonDate: 2004-02-25 22:08:55
Subject: Re: Scalar in a range (but textual not numeric)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group