Home > mailing lists

How to select by proximity - Mailing list pgsql-novice

From	Francisco Leovey
Subject	How to select by proximity
Date	May 14, 2012 18:01:08
Msg-id	1337018449.10244.YahooMailNeo@web39304.mail.mud.yahoo.com Whole thread Raw
Responses	Re: How to select by proximity
List	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?

From: Steve Crawford
Date: 14 May 2012, 15:46:40
Subject: Re: Unwanted time zone conversion

From: Postgres
Date: 14 May 2012, 20:24:48
Subject: Re: How to select by proximity