select offset by alphabetical reference - Mailing list pgsql-general

From Dave [Hawk-Systems]
Subject select offset by alphabetical reference
Date
Msg-id DBEIKNMKGOBGNDHAAKGNOEHMNOAB.dave@hawk-systems.com
Whole thread Raw
Responses Re: select offset by alphabetical reference  (Oliver Elphick <olly@lfix.co.uk>)
Re: select offset by alphabetical reference  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Have a table with Last, First, etc...
wish to create a select to grab everything from table whose last name is
alphabetically greater than 'Smith'

almost like the following (which is obviously incorrect);
    select last,first from mytable order by last offset 'Smith';

ideas on how to handle this at the postgres level rather than grabbing all and
storing it in an array in PHP/Perl for post processing to grab the desired
records?

thanks

Dave


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Small bug in postgres' ./configure script and invalid
Next
From: Oliver Elphick
Date:
Subject: Re: select offset by alphabetical reference