Re: 8.4.1 distinct query WITHOUT order by

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: 8.4.1 distinct query WITHOUT order by
Дата
Msg-id dcc563d10912212118w2e78a715k49dc0a8fcecd63dd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.4.1 distinct query WITHOUT order by  (Gary Chambers <gwchamb@gmail.com>)
Ответы Re: 8.4.1 distinct query WITHOUT order by  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-sql
On Mon, Dec 21, 2009 at 8:45 PM, Gary Chambers <gwchamb@gmail.com> wrote:
>> Yeah, if you're code base is that fragile, bandaging it up by jumping
>> through hoops in pgsql is just putting off the inevitable when it (the
>> code base) has to get recompiled someday anyway.
>
> I appreciate (and agree with) the concern about the fragility of the
> codebase.  The maintainer knows that anything except adding ORDER BY
> is a kludge.
>
> Now, the aforementioned notwithstanding...

Replacing the table with a view should work.  Just be sure to make
insert rules if you need it to be insertable by other parts of the app
I guess.


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

Предыдущее
От: Gary Chambers
Дата:
Сообщение: Re: 8.4.1 distinct query WITHOUT order by
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: 8.4.1 distinct query WITHOUT order by