Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-22 Thread Scott Marlowe
On Tue, Dec 22, 2009 at 12:11 AM, msi77 wrote: >> What are the ramifications of renaming the table (containing 8000 >> rows) and creating a view of the same name? > > View does not admit ORDER BY clause, at least, Standard does not. Postgres certainly allows it, but I don't think it will help in

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread msi77
> What are the ramifications of renaming the table (containing 8000 > rows) and creating a view of the same name? View does not admit ORDER BY clause, at least, Standard does not. Sergey -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread Scott Marlowe
On Mon, Dec 21, 2009 at 10:18 PM, Scott Marlowe wrote: > On Mon, Dec 21, 2009 at 8:45 PM, Gary Chambers 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

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread Scott Marlowe
On Mon, Dec 21, 2009 at 8:45 PM, Gary Chambers 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

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread Gary Chambers
> 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 t

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread Scott Marlowe
On Mon, Dec 21, 2009 at 3:38 PM, Thomas Kellerer wrote: > Gary Chambers wrote on 21.12.2009 23:15: >> >> The current maintainer is unsure about being able to do the right >> thing and recompile the code after fixing the query. > > Why not simply add the necessary GROUP BY? Yeah, if you're code ba

Re: [SQL] 8.4.1 distinct query WITHOUT order by

2009-12-21 Thread Thomas Kellerer
Gary Chambers wrote on 21.12.2009 23:15: The current maintainer is unsure about being able to do the right thing and recompile the code after fixing the query. Why not simply add the necessary GROUP BY? Thomas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to y