Re: 8.4.1 distinct query WITHOUT order by - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: 8.4.1 distinct query WITHOUT order by
Date
Msg-id dcc563d10912212118w2e78a715k49dc0a8fcecd63dd@mail.gmail.com
Whole thread Raw
In response to Re: 8.4.1 distinct query WITHOUT order by  (Gary Chambers <gwchamb@gmail.com>)
Responses Re: 8.4.1 distinct query WITHOUT order by  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: Gary Chambers
Date:
Subject: Re: 8.4.1 distinct query WITHOUT order by
Next
From: Scott Marlowe
Date:
Subject: Re: 8.4.1 distinct query WITHOUT order by