Re: 8.4.1 distinct query WITHOUT order by

On Mon, Dec 21, 2009 at 10:18 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Mon, Dec 21, 2009 at 8:45 PM, Gary Chambers <gwchamb(at)gmail(dot)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.

Actually, since the order by in the view will be applied before the
hash_agg and stuff, I don't think it will work.