On Mon, Dec 21, 2009 at 10:18 PM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Mon, Dec 21, 2009 at 8:45 PM, Gary Chambers <gwch...@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.
Actually, since the order by in the view will be applied before the hash_agg and stuff, I don't think it will work. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql