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

How to select by proximity

From: Francisco Leovey <fleovey(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: How to select by proximity
Date: 2012-05-14 18:00:49
Message-ID: 1337018449.10244.YahooMailNeo@web39304.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello group
 
I have a large table indexed by a varchar column
I would like to select records that are around the hit value, say "Marriot" by index order
How can I retrieve the prior and next in order? 
Is there a goto "Marriot" and then a goto +1 and goto -1 SQL facility?

Responses

pgsql-novice by date

Next:From: PostgresDate: 2012-05-14 20:24:28
Subject: Re: How to select by proximity
Previous:From: Steve CrawfordDate: 2012-05-14 15:46:27
Subject: Re: Unwanted time zone conversion

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