find next in an index

Поиск
Список
Период
Сортировка
От Neil Dugan
Тема find next in an index
Дата
Msg-id 1108263782.6024.15.camel@postgresql.localdomain
обсуждение исходный текст
Ответы Re: find next in an index  (Bruno Wolff III <bruno@wolff.to>)
Re: find next in an index  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field.  The name field
isn't unique so I made an index on name(varchar) & serialno(bigserial).
I also have an index just on 'name'.  I am having trouble working out
the syntax for the query.

select * from table where name>='jack' and serialno!='2'
order by name,serialno;

I don't think this will work under all circumstances.

Any help appreciated. Thanks.





В списке pgsql-general по дате отправления:

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: Website Documentation
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Website Documentation