select offset by alphabetical reference

Поиск
Список
Период
Сортировка
От Dave [Hawk-Systems]
Тема select offset by alphabetical reference
Дата
Msg-id DBEIKNMKGOBGNDHAAKGNOEHMNOAB.dave@hawk-systems.com
обсуждение исходный текст
Ответы Re: select offset by alphabetical reference  (Oliver Elphick <olly@lfix.co.uk>)
Re: select offset by alphabetical reference  (Manfred Koizar <mkoi-pg@aon.at>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: Small bug in postgres' ./configure script and invalid
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: select offset by alphabetical reference