Re: Overriding natural order of query results for a subset

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Overriding natural order of query results for a subset
Дата
Msg-id CAKFQuwa2avyUMCWOx5WQhcKB_KkuO+2M1m6K--nNyC3kman-VQ@mail.gmail.com
обсуждение исходный текст
Ответ на Overriding natural order of query results for a subset  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
Список pgsql-general
Дерево обсуждения

On Saturday, May 29, 2021, Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch> wrote:

The problem is that my use-case calls for a scenario where due to protocol certain people may be designated as "VIP" and therefore need to appear at the top.  In addition, protocol may dictate that those "VIP" people themselves may (sometimes but not always) need to be ordered in a specific manner.

Add whatever attribute(s) determine vip status to your order by clause.

David J. 

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

Предыдущее
От: Laura Smith
Дата:
Сообщение: Overriding natural order of query results for a subset
Следующее
От: Michael van der Kolff
Дата:
Сообщение: Re: Overriding natural order of query results for a subset