select offset by alphabetical reference

From: "Dave [Hawk-Systems]" <dave(at)hawk-systems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: select offset by alphabetical reference
Date: 2003-05-07 05:50:47
Message-ID: DBEIKNMKGOBGNDHAAKGNOEHMNOAB.dave@hawk-systems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-05-07 06:19:00 Re: select offset by alphabetical reference
Previous Message Oliver Elphick 2003-05-07 05:41:06 Re: Small bug in postgres' ./configure script and invalid