| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Gary Chambers <gwchamb(at)gmail(dot)com> |
| Cc: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: 8.4.1 distinct query WITHOUT order by |
| Date: | 2009-12-22 05:18:11 |
| Message-ID: | dcc563d10912212118w2e78a715k49dc0a8fcecd63dd@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-12-22 05:23:11 | Re: 8.4.1 distinct query WITHOUT order by |
| Previous Message | Gary Chambers | 2009-12-22 03:45:27 | Re: 8.4.1 distinct query WITHOUT order by |