Re: select offset by alphabetical reference - Mailing list pgsql-general

On Wed, 7 May 2003 01:50:47 -0400, "Dave [Hawk-Systems]"
<dave@hawk-systems.com> wrote:
>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';

SELECT last, first FROM mytable WHERE last > 'Smith' ORDER BY last;

Servus
 Manfred